Monday, March 15, 2010

Disable accessing a hidden sheet in Excel workbook

I had a requirement today to not display the hidden worksheets in an excel workbook when you try to unhide sheets. Here are the steps I have taken to achieve this.

  • 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

No comments:

Two ways to reset the identity of a table in sql server.

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...