protection

[Guest]

Hi

Lotus 123 had a protection choice
that allowed macro execution.
Is there a setting or VBA code equivalent
in Excel or is it necessary to toggle the
protection setting in the procedure.


Thanks
TK

 

[Tom Ogilvy]

the userinterfaceonly argument to the protection method (for worksheets)
allows macro execution. It can only be set with code and is non-persistent
in that if you close and reopen the workbook, the setting always defaults to
False. In xl2002 and later, you have to supply the password to change this
setting. In earlier versions, you were not required to.

 

[DMoney]

Macro control is primarily done at the application
level. goto Tools..Macro..Security to see the options.

HTH