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.ToolMacromacros

Can this be turned of when opening the workbook?

Thanks in advance.

Bernd

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

Private Sub test()

--


Gary


"bernd" wrote in message
ups.com...
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.ToolMacromacros

Can this be turned of when opening the workbook?

Thanks in advance.

Bernd

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)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just name it private and it won't show in the list.
for example:

Private Sub test()

--


Gary


"bernd" wrote in message
ups.com...
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.ToolMacromacros

Can this be turned of when opening the workbook?

Thanks in advance.

Bernd

Thanks, the option Private Module works for me.