I have a workbook setup to run a few macros when it is opened. I locally built the spreadsheet and saved it to a network for others to use.
I have never had an issue till this morning. The issue doesn't occur if I open the workbook locally.
I get run-time error 1004 upon opening and it points to the code executed. below is an example of some code that errors.
I think it is an issue when the workbook is copied from my local to the network. I can work around the error by activating the current worksheet.
Any help on this would be appreciated.