Macro to load another workbook

[Catsonheat]

Hi all,

I have a macro which is designed to open another spreadsheet in order for formula in another spreadsheet to read from it. The macro I have works, it opens the file and my formula all work however the macro still debugs every time on the open workbook line even though it has actually found and opened the file!

Can anyone assist and help? The debug message is: Run Time Error 1004 - Unable to set the hidden property of the range class

Many thanks in advance!

Please Login or Register  to view this content.

[Norie]

Is there any code in the workbook you are opening that is triggered when the file is opened?

[Catsonheat]

It is someone elses worksheet which unfortunately I don't have complete access to however once i saw your comment i dug around a bit further and found that you were right, the sheet i am loading is trying to run a macro when it opens which itself does not work! this is causing mine to debug, so problem found! at least it wasn't anything wrong with my code haha.

Is there any way I can get around the Debug? Such as a macro to select 'End' or something so it actually runs right to the end because the macro itself has worked and the file has loaded!

Any tricks?

[Norie]

What you could do is disable events, open the other workbook and then enable events again.

Something like this.

Please Login or Register  to view this content.

[Catsonheat]

Brilliant! That has worked perfectly! Thanks for the help!