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

[jaybostonusa]

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!

 

[Jon von der Heyden]

Go to Tools->Macro->Security and choose Low.

 

[JazzSP8]

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]

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