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.
Bookmarks