manually run macro's

[bernd]

Hello,

I've a workbook which I want to protect. I protected the sheet etc
already. But it is still possible to run macro's manually trough the
menu bar.Tool>Macro>macros

Can this be turned of when opening the workbook?

Thanks in advance.

Bernd

 

[Gary Keramidas]

just name it private and it won't show in the list.
for example:

Private Sub test()

 

[Bob Phillips]

or add

Option Private Module

to the start of the module

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[bernd]

Thanks, the option Private Module works for me.