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:

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...