CODEWITHSUNDEEP
vbaexcelexcel-2007
brucebadeau
brucebadeau

Reputation: 11

Protecting Excel Module Code (.dll?)

We have just written an Excel VBA Oil and Gas Reservoir analysis program with lots of Active X controls and many code modules. (Excel 2007 with a 1000 x 1000 calculating C++ grid running in the background some of the more daunting calculations).

We are concerned about security. Locking the Worksheets or Workbook does not prevent a right-click/View Code, which exposes all of the modules.

Should we or can we convert or write these Modules into .dlls? Is there any literature to consult?? So far, I can't understand anything that I have found on the web.

Is there another way of protecting the module by password?

Comments and thoughts greatly appreciated.

Upvotes: 1

Views: 657

Answers (1)

chris neilsen
chris neilsen

Reputation: 53126

From your post, it seems you need to set the VBA project protection: in the VBA editor, right-click the project in the Project Explorer window, select Properties\Protection.

That said, there is much discussion on SO and the web generally on the (lack of) strength of Office VBA protection and the ease of cracking it. Given you mention a 'C++ grid' component, it would seem you already use externally (to Excel) developed components: if security is a major concern it may be best to develop the whole app in VSTO.

Upvotes: 2

Related Questions