ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   en-/disable macros pop-up (https://www.excelbanter.com/excel-programming/272337-en-disable-macros-pop-up.html)

James[_10_]

en-/disable macros pop-up
 
anyone know what the line is that stops the "do you want
to enable or disable macros?" box popping up on opening
(and enables macros)?

thanks

John Wilson

en-/disable macros pop-up
 
James,

Can't be done programmatically.

You have three options under Tools/Macro/Security

High - Macros will not be enabled and you won't be prompted
Medium - You'll be asked whether to enable or not
Low - You won't be prompted and macros will automatically be enabled.

Read the descriptions of each when you get to that dialog box.

John

James wrote:

anyone know what the line is that stops the "do you want
to enable or disable macros?" box popping up on opening
(and enables macros)?

thanks




All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com