Protect a Macro

[Darin Kramer]

Howdie All,

I have a workbook with many macros in, some I use for design, and would
not like users to be able to run them, (which they can currently easily
do by selecting Tools...macro...run...)

So the question is, can I protect some macros from being run?

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

[Brian Matlack]

Darin:
This will prevent the user from accessing the macro from the Tools menu.

Sub macro1(Optional HideRoutine As Integer)

Brian M.

[Zone]

You can use the Private keyword with your macro to prevent it from
showing in the list of macros, such as

Private Sub Macro1()

[Chip Pearson]

If you put

Option Private Module

as the first line of code in your code module, none of the macros
in that module will be listed in the Macro Dialog. If, however,
the user knows the name of the macro, he can type it in the
dialog and get it to run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Darin Kramer" <darin_kramer@hotmail.com> wrote in message
news:OsLIAo3cGHA.3908@TK2MSFTNGP04.phx.gbl...
>
>
> Howdie All,
>
> I have a workbook with many macros in, some I use for design,
> and would
> not like users to be able to run them, (which they can
> currently easily
> do by selecting Tools...macro...run...)
>
> So the question is, can I protect some macros from being run?
>
> Regards
>
> D
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Ivan Raiminius]

Hi Darin,

you can also use useless optional parameter:

Sub macro1(optional useless as variant)

macro1 will not be visible to the user in macro>run, but you will not
have any problems in your code with this useless parameter (maybe you
could have problems with making the sub private).

Regards,
Ivan

[Darin Kramer]

Thanks all for your feedback!!

Regards

Darin



*** Sent via Developersdex http://www.developersdex.com ***