View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Hiding part of VBA or a Module in Macro

Obviously password protect the VB Editor, but 'Option Private Module' at the
beginning of the code stops the macro being visible at all. A user can run
it via a Button or whatever, but they can't see it.
Regards,
Alan.
"Iraj" wrote in message
...
Once again Hi all:
How can I hide the module or Part of VBA in a Macro that other user can't
see what I have done?