Code playing up if other spreadsheets are open

[TheWennerWoman]

Hello,

I have some code that is triggered when a workbook is opened (basically, a "you must enable macros" sheet is hidden and another sheet is made visible and active).

This works fine if the workbook is the only one open but if there is more than one spreadsheet open then the "you must enable macros" sheet hides just fine but the second sheet doesn't get made visible.

Any thoughts?

Thanks for reading.

 

[MARK858]

Include the workbook in the line to open the sheet.

Workbooks("YourWorkbookname").WorkSheets("YourSheetName")

or use ThisWorkBook

ThisWorkBook.WorkSheets("YourSheetName")

 

[TheWennerWoman]

Works a treat, many thanks!

 

[MARK858]

You're welcome