protecting or hiding excel macros


Posted by steven schouela on January 30, 2002 10:32 AM

For proprietary reasons I would like to know if there is a way to hide or protect excel macros that I wrote in Visual Basic similar to the way worksheet cells are protected. I tried playing with deleting the "Tools" menu in the MenuBar but I could not reinstate it. without having to reset the entire Menu Bar. In any case the macros would be viewable if the user had the "warn before enabling macros" turned on. The reason for my interest is that I want to circulate an excel worksheet application that I wrote without having the code made public.
Any suggestions?
Thanks Steven



Posted by Matt on January 30, 2002 10:36 AM

In the VB Editor

Right click on the VBProject("YourWorkBook")
Click the Protection tab
Click the Lock project from viewing
Type in your password

Good luck