Run-time error '1004': Method 'Worksheets' of object '_Global' failed

[JSebastianRock]

Run-time error '1004': Method 'Worksheets' of object '_Global' failed

I get this error when running the following code:

Please Login or Register  to view this content.

I just want to add a sheet at the end of the workbook. This code used to work just fine with Windows XP and Office 2007. We recently updated to Windows 7 and Office 2010 and now the code breaks at the Set NWS line. Am I missing a reference somewhere? Thanks for any suggestions!

[Norie]

Is there more than one workbook open?

If there is then you should add workbook references.

Please Login or Register  to view this content.

[JSebastianRock]

Is there more than one workbook open?

No, there is only one open. I stored the code in Personal.xlsb, but I doubt that would matter. I tried including your code just in case, but the file is downloaded from an internet server, so the file name changes to somthing random each time.

[Norie]

There are 2 workbooks open - the personal workbook and the workbook you have downloaded/opened.

In the code I posted try changing Workbooks("Book1.xlsm") to ActiveWorkbook.

[JSebastianRock]

Well, after I opened my eyes, I found the issue. This workbook is downloaded from an internet server, and Office 2010 uses Protected View for internet sources whereas 2007 did not. Interesting.. I just disabled that function and it works like a charm

Capture.PNG

[Norie]

I think Excel has always had some sort of protected view thing.

You can change settings to disable the message and allow the file.

[JSebastianRock]

Possibly, but it never kept me from editing a downloaded file before So much for protection lol Microsoft never ceases to amaze..