Changing the default setting that disables macros.

D. Drago · Mar 28th, 2002, 11:28 AM

My spreadsheets all open with disabled macros. The message text that used to ask me if I wanted to enable them does not run. I cannot find a help topic that deals with this problem.

Juan Pablo González · Mar 28th, 2002, 11:45 AM

Check your security level. If you're using 2000 or XP, it must be set to HIGH. Other wise, in Tools, Options, make sure that "Protection against macros" is checked

D. Drago · Mar 28th, 2002, 12:05 PM

I cannot find the "protection against macros" setting you spoke of. Can you provide more information?

Juan Pablo González · Mar 28th, 2002, 12:09 PM

Are you using Excel 97 ?

Mar 28th, 2002, 11:45 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,931	Check your security level. If you're using 2000 or XP, it must be set to HIGH. Other wise, in Tools, Options, make sure that "Protection against macros" is checked __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 28th, 2002, 12:09 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,931	Are you using Excel 97 ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 11:28 AM	#1
D. Drago New Member Join Date: Mar 2002 Posts: 3	My spreadsheets all open with disabled macros. The message text that used to ask me if I wanted to enable them does not run. I cannot find a help topic that deals with this problem.

Mar 28th, 2002, 12:05 PM	#3
D. Drago New Member Join Date: Mar 2002 Posts: 3	I cannot find the "protection against macros" setting you spoke of. Can you provide more information?