Hiding part of VBA or a Module in Macro

  • Thread starter Thread starter Iraj
  • Start date Start date
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.
 
Great and Thanks Alan for promp answering.

Alan said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba macro that allows insertion of symbols at cursor 0
Basic VBA question - hiding rows 5
Running 4 macros at once 2
Chaining 6 macro modules 3
macro to hide columns with zero values? 2
Having a macro/function available in new spreadsheets 1
Excel Query setup 0
Can Vba workout if a selection is part of a group? 0

Back
Top