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