Run-time 1004 Workbook Open

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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

Any help on this would be appreciated.

Cheers,

nKife