Stop the "disable or enable?" macros pop-up

jaybostonusa

New Member
Joined
Jul 4, 2006
Messages
15
Every time I open my Excel docs, I get a pop-up asking me to "disable or enable macros?." It's annoying. I always choose ENABLE. Can I do anything about this?

Oh, and another question......

(not Excel related): Whenever I open a folder in windows, my view format is "Tiles" - I prefer LIST. Where can I change this setting?

I love this forum man!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,218
You can disable the message by going to the Tools Menu, selecting Macro then Security, finally change the setting to low.

Be warned though, if you download any spreadsheets from Emails or the Internet that contains malicous code your leaving yourself open.

For your Windows Folders, open the folder and go to "View", change to list and it (should) always be the list view when you open it.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Yes you can change security to Low, but it's a dangerous thing to do.
You will compromise your system if you do that. If you think about it, there is a good reason why you can't disable the warning in code -- it prevents virus writers from being able to deliver infected workbooks / Word documents without your knowledge.

If you want you can self-certify the code in the workbook, and that will prevent the message until you update the code, then you will most likely need to do it again.

Search this forum and Google for more info on how do this.

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,114,380
Messages
5,547,599
Members
410,802
Latest member
DataMgmtAnalyst7
Top