Preventing users from accessing VBE code

[Dan Pensions]

Hi, I have a spreadsheet which uses a macro.

The spreadsheet itself is protected with the exception of a few essential cells but I cannot seem to find a way of preventing the user from accessing the macro code by pressing alt-F11.

This is a particular problem as the code unlocks the cells temporarily while it updates some of them so the password is visible to all and can easily be changed.

As a result I am looking not only to write-protect the code but to hide it from the user completely.

Any suggestions as to how to achieve this will be greatly appreciated.

cheers, Daniel

 

[Excelenator]

If you go to the VBE and right click on the project you want to protect, select properties, and then the tab for protection. You can then check the "Lock project for viewing" checkbox and type in a password and confirm it. Then save the project in the VBE and your code should be semi secure. Semi secure because this protection can be cracked with code easily obtained on the net, however, for novice users this probably won't be much of an issue.

 

[Richard Schollar]

The Lock Project for Viewing really only works with viewing the code from within the VBE (and as Excelenator has already mentioned, it isn't completely secure) - if someone was to open up the workbook eg in Notepad, it is still possible to reconstruct the code that you have created.

Best regards

Richard

 

[Dan Pensions]

Cheers guys all good now.

I did try that before but i didn't realise you had to exit and re-open the file so i thought it hadn't worked!

thanks, Daniel