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