Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Friends,
In my Excel Project, I have hidden all VBA code modules by inserting 'Option Private Module' in the General Declarations section; I have also password protected the VBA project. Question: I have a command button on one worksheet - the button has VBA code behind it (simple code that calls a sub proc from a code module). I would like to hide the code behind the button, but there seems to be no way to hide code that is in an Object Module (as opposed to a standard Code Module). Any way to hide code that is behind a command button so user cannot go into VB design mode and see that code behind the button? Note: Assume that protecting the worksheet is not an option. Thanks in advance ... Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Private Module | Excel Programming | |||
Improve method of calling a private function in a private module | Excel Programming | |||
Option Private Module | Excel Programming | |||
Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
Option Private Module not preventing cross project referencing | Excel Programming |