- 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
Yesterday I had a situation where a couple of SSRS reports failed due to a network upgrade. The SSRS report was not able to access the SQ...