Check Workbook

[thundermocos]

I had this macro that would check if Spreadsheet "Wrong One" was the active spreadsheet the macro would end the program and tells us Wrong One was active. I have to transfer data from one spreadsheet to Wrong One daily, but the spreadsheet I am copying from is always changing. So, I created a macro to help the copy/paste/formatting go smoother, but sometimes i forget that the active workbbook is "Wrong One" and it runs the macro on the wrong workbook. I want to create a sub routine that will first check and make sure that spreadsheet "Wrong One" is not the active spreadsheet before it starts the rest of the process.

[Leith Ross]

Hello Thundermocos,

Add tis to code to check if the sheet is active...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[thundermocos]

Thanks Leith!

I was using

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.