prevent sb from running macros from list

A

as_sass

Hi,

Is there a way to prevent people from running macros usin
tools\macros?
I have some macros that are associated with buttons in my workbook.
I want people to be able to click the buttons, but not to run (or mayb
even see) the macros from the list of macros under the tools menu!

As usual, any help is appreciated.

a
 
D

Don Guillett

If you put this line at the top of your module the macros will not be seen.
You can also protect the code to further protect.

Option Private Module
 
G

Gord Dibben

Make them Private Subs

Private Sub Test()
'your code here
End Sub

Gord Dibben Excel MVP
 
Top