prevent sb from running macros from list

[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

 

[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

 

[Gord Dibben]

Make them Private Subs

Private Sub Test()
'your code here
End Sub

Gord Dibben Excel MVP