- Open the VBE (alt-f11)
- Go to the sheet that you want to disable in the unhide option
- View properties window
- Change Visible property to 2 -XlSheetVeryHidden.
- Save and close
Test the unhide option
Today I had a requirement from one of my customer to export data from two different tables generated out of SSRS reports into two different...