- 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
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.
Test the unhide option
Test the unhide option
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des... -
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment