How can I open several files without clicking "Disable Macros" or other button each time?

[StuCram]

Hoping the get a tip from the forum members . . .

I have several similar registration files from many gymnastic clubs and want to open each one as read-only in order to copy the list of entrants into a master file. Most of this is working but as each file is opened, there is a dialog saying the file has macros and three buttons: 'Enable Macros', 'Do Not Open', and 'Disable Macros', the last being the default.

Is there a simple way to skip this dialog in the opening sequence of each file and have the "Disable Macros" automatically selected. That would make my program much more automatic so the user need not press 'return' or 'enter' for each file in order to open it. Maybe there's an option in the OPEN statement?

This is what I use now: (The colon is for Mac OS.)

Please Login or Register  to view this content.

- Stu

[p24leclerc]

I'm not sure if this works for Excel on Mac but you could change the Macro Settings in the Trust Center of the Excel Options menu.
You select Disable all macros without notification.
But for a VBA solution see this answer on MrExcel web site

[StuCram]

Thank you Pierre L

I found a similar option in the Mac version.
I will include a note about this in the user's guide for the program.

Merry Xmas.
- Stu