- 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)
Building True Tracing for Multi-Step AI Pipelines
Debugging traditional software applications relies on call stacks, HTTP status codes, and line by line log traces. Debugging non-determinist...
-
40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attent...
-
Did you know that you can connect to your Power BI Desktop Model from Sql Server Management Studio (SSMS)? If not, this blog post is fo... -
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
No comments:
Post a Comment