Strange. I am still getting the error as soon as the worksheet is opened! I did not protect any Worksheet and your Macro Sheet is the only one open. The choices on the error are Help, Continue, End or Debug. If I click on End, then I can click on the START Button which changes to PAUSE and the timer starts. However, if I click on PAUSE, the same error pops up. I wonder if its something specific to Mac Excel.
Now I tried the Debug button and the code highlighted when the spreadsheet is first opened is
If I click on End, and continue the Macro's and click on PAUSE, the Debug highlighted code is
If I click on RESET, the Debug highlighted code is
Strange indeed!
Bookmarks