I have a workbook created in Excel 2007, consisting of 3 sheets (Expenses, Instructions and Lists). When the workbook is opened, the user only sees the "Expenses" sheet, the other 2 are hidden.

I have created a simple macro which unhides the "Instructions" and "Lists" sheets in order that I may update data on these sheets (see code below).

This is working in Excel 2007, but not in Excel 2013. In Excel 2013, I can see the sheet "Lists", but any changes I make on this sheet appears in the corresponding cells on the sheet "Expenses". I can not change any data on the "Lists" sheet.

I would like to know what changes I need to make to my code, in order for it to work in Excel 2013.

Any assistance will be appreciated.

Please Login or Register  to view this content.