MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VBA. Is it possible to hide code or modules without using a Password?


Posted by Julio on October 11, 2000 7:21 AM


Is there anyway to hide the code or the modules from the user? I don't want to place a password, just hide the code...


Thanks!


Posted by Jim Knicely on October 11, 2000 11:04 AM

In Excel 97 and above, the xlVeryHidden property for modules - which used to hide the code - is no longer supported. You can hide module code like procedures from showing up in the macro list by decrlaring them as private or with a dummy paramter. Also, I don't think it's possible to diable the VB editor ... The only way I can think of is by hiding the menu option and disabling the short cut key ... But there are easy ways around that.

Posted by Julio on October 11, 2000 2:17 PM


Jim:

Here at work it's difficult to place a password on a file, as it seems that you are not a very good teamplayer. On
the other hand, I've seen far too many times people's work being ripped off and
presented as brand new by others. What to do? That's why
I figured hiding the code and not placing a password would be a good
solution; although, I kind of new that it would be difficult to do...

Anyways, thanks a lot for all your help; and if any one out there has
deviced any way to deal with this situation at work, I would really appreciate
their comments!

Thanks again!