manually run macro's

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bernd - 20 Aug 2007 14:15 GMT

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

Reply to this Message

Gary Keramidas - 20 Aug 2007 14:34 GMT

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

Private Sub test()

Signature

Gary

> Hello,
>
[quoted text clipped - 7 lines]
>
> Bernd

Reply to this Message

Bob Phillips - 20 Aug 2007 15:57 GMT

or add

Option Private Module

to the start of the module

Signature

HTH

Bob

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

> just name it private and it won't show in the list.
> for example:
[quoted text clipped - 12 lines]
>>
>> Bernd

Reply to this Message

bernd - 21 Aug 2007 19:47 GMT

Thanks, the option Private Module works for me.

Reply to this Message