Protect VBA.Marcos

[antony moseley]

Hi,

Anyone with half a brain, will know if you press ALT and F11 to get you can get to coding in a spreadsheet, is there any way of preventing this?

Thanks

Antony

[DonkeyOte]

Have you considered protecting the Project of interest ?

http://www.ozgrid.com/VBA/protect-vba-code.htm

Immediate Window will still be accessible but I have some code c/o Romperstomper that can disable that also if really nec. (not advised)

Note: nothing is 100% secure in XL... those determined enough can circumvent whatever security you put in place.

[ebin charles]

Yes,

You navigate to Alt+F11 and go to Project Explorer and
Right Click the in the module and go to VBA Project Properties.

There you find Protection Tab, Lock the Project for viewing with Password in the below requested place.

Thus you can protect your code.

regards
Charles