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

Sean

Make the Subs Private to prevent users from seeing them in ToolsMacro

In addition you could protect the VBA Project.

Select the project and right-clickvbaproject propertiesprotectionlock 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 toolsadd-ins.


Gord Dibben MS Excel MVP


On Sat, 1 Dec 2007 08:15:22 -0800 (PST), Sean wrote:

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

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?

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

--
Tim Zych
SF, CA

"Sean" wrote in message
...
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

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

On Sat, 1 Dec 2007 12:01:00 -0800, "Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET
wrote:

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

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