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.)
  
Workbooks.Open filename:=folderPathname & ":" & registrationFileName, ReadOnly:=True
- Stu