I have hidden all the sheets in a workbook except Sheet1, on which I have multiple Activex buttons.
When I click on Button1, it goes on the sheet2 and on sheet2 i have a "back" button that once i click on it, will bring me back to sheet1
I have 10 buttons like this.
Since I have hide all the sheets except Sheet1, i really don't know how I can activate a sheet, It does give me an error message.
Any suggestion how I can resolve that issue (work with hidden sheets but been able to access it when i press an activex button)
Thanks in advance,