Two workbooks open, code changing wrong Wb, help!

[thecdnmole]

Hi, I have the following code and at line 200 the wrong workbook is having cells unprotected. How do I make the "final" workbook change and not the "Backup"? Having a brain fart today Thanks for the help!

Please Login or Register  to view this content.

[Norie]

You need to add a workbook reference to the code to make sure it executes on the correct workbook.

Please Login or Register  to view this content.

[thecdnmole]

Thanks Norie, I tried that and get "Runtime error 9""Subscript out of Range".

[Fluff13]

You are using the sheet codename, but you can only use that directly for the workbook containing the code.
So you need to use the actual sheet name as shown by Norie, if you are getting an RTE 9 then it means the sheet name is wrong.

[Norie]

You need to use the sheet tab names rather than codenames.

So change Sheets("Sheet1") to Sheets(tabname) where tabname is the tab name of the sheet with the code name 'Sheet1'.

[thecdnmole]

You need to use the sheet tab names rather than codenames.

So change Sheets("Sheet1") to Sheets(tabname) where tabname is the tab name of the sheet with the code name 'Sheet1'.

Odd, I tried that as well with same error.

[Norie]

Where are you getting the error?

Have you checked the sheet names for leading/trailing spaces?

[thecdnmole]

Good grief, I entered the tab names and did not think I put a space, but yes, there was a space!! Thanks for your help Norie.