I am attempting to run a macro that unhides a sheet. The issues is that the workbook contains 5 worksheets (let's call them Sheet1-Sheet5) that may be needed, but I only want 1 unhidden at a time.

If there is a macro to hides them one at a time as well that would be brilliant.

Cheers,
C