Hide Macro from View Q

[Sean]

I have some code that I use in developing sheets, things like
"unprotect all" sheets etc, standard stuff that I like to keepwithin
sheets. Problem with this is that a User with a small bit of knowledge
can simply go to Tool-Macro and run the "unprotect all" code, which
can free up a lot. Is there any simple way around this, apart from
removing the macro itself?

Thanks

 

[Gord Dibben]

Sean

Make the Subs Private to prevent users from seeing them in Tools>Macro

In addition you could protect the VBA Project.

Select the project and right-click>vbaproject properties>protection>lock for
viewing.

Provide a password and save.re-open the workbook.

Alternative...............place all your macros into a new workbook then save as
an add-in which you load through tools>add-ins.


Gord Dibben MS Excel MVP

 

[Sean]

Thanks Gordon, I have the VBA project password protected already.

Q - Difference between private and Public, what is that? apart from
the fact that the user can't see within Tool-Macro.

How do you make a macro private?

 

[Tim Zych]

You can also add Option Private Module at the top of the module(s). That
will hide the macros from the Tools->Macros dialog.

 

[Gord Dibben]

Thanks for jumping in Tim.

Less work than adding Private to each Sub which would be the answer to

How do you make "a" macro private?


Gord

 

[Sean]

Classic guys, thanks, I always thought that code within the sheet and
not a standard module was "Private" - thanks