Protect VBA Code from Viewing/changing

[JesseH]

Is there a simple way to prevent the "typical" user from viewing/changing the VBA. But I want to make sure that the cure is not worse than the illness. Using MS password creates problems with some other VBA Code and I can not use it. I am trying to find a simple way that will keep most folks out. The determined user will always find a way.

Thanks

 

[DCrake]

In the VBA Editor got to Tools an Properties and select protection. You can enter a password there to prevent unauthorised access.

 

[JesseH]

I tried this, but this conflicts a VBA routine that creates automatic backups. When the VBA attempts to automatically create a backup, excel says that the file can not be saved. I did some research on the web and I can disable alt F11, etc. But I was looking for a simple approach the will keep the curious out and knowing that gurus will be able to get in.

I may be dreaming.


Thanks for responding