- 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
I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...