I have a spreadsheet where I want to hide empty rows and sheets if they are not going to be used. Because I have a few sheets that I want to have these macros on, I have put all the buttons on the first sheet.
I want a macro that will unhide all of the rows, but on the same button I also want it to unhide the sheet if it is hidden. What I have at the minute is:
Sheet1 is where I want all the buttons
Sheet2 is the sheet that may be hidden and may have hidden rows
This macro unhides Sheet2 but selects and unhides rows 15:316 on Sheet1, which were never hidden.
Any help would be great!