P
Peter
Sometimes when I click a button in an excel sheet, I got message "macro disabled". Please advice how to enable. Thanks
Peter
Peter
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
In xl2k or higher:
Tools|Macro|Security
(set it to medium to be prompted each time you open a workbook with code
set it to low to avoid the prompt--ms doesn't recommend this one)
In xl97, I think you're limited to just two options (enable or disable macros).
Tools|Macro|Security
(set it to medium to be prompted each time you open a workbook with code
set it to low to avoid the prompt--ms doesn't recommend this one)
In xl97, I think you're limited to just two options (enable or disable macros).
T
Tom Ogilvy
close the workbook, then reopen it and don't choose to disable macros.
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
disabled". Please advice how to enable. Thanks.Peter said:Sometimes when I click a button in an excel sheet, I got message "macro
T
Tom Ogilvy
Another possibility
In Excel 2000 and later, set your security setting to medium.
--
Regards,
Tom Ogilvy
In Excel 2000 and later, set your security setting to medium.
--
Regards,
Tom Ogilvy
disabled". Please advice how to enable. Thanks.Peter said:Sometimes when I click a button in an excel sheet, I got message "macro