» Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
CATEGORY - Excel Customizing , General Topics in VBA
VERSION - All Microsoft Excel Versions
Tip submitted by Kedar Kulkarni, Pune India
To hide a sheet so that no body can unhide it without knowing the password for the Vb Project, simply open the VB Editor and change the visible property to 2 i.e. xlsheetveryhidden.
The sheet should disappear from the Unhide sheets command.
The only way to unhide it is to change the property back to 0 i.e. xlSheetNormal using the password to the VBProject.
Book Store:
Recommended Books:
- Financial Reporting and Analysis (2nd Edition)
- Yes, You Can Time the Market!
- Microsoft Excel Version 2002 Step by Step
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Excel VBA Programming for the Absolute Beginner
Errata : We need to protect workbook also
Kedar Kulkarni Posted on: 31-12-1969
A Small Explanation: If the workbook is not protected then a person can unhide this worksheet if he knows that the Worksheet exists as we can use the sheets collection and we can refer to the property with sheets(i).visible property. (Thanks Mandar - my brother for pointing this mistake)Unhiding worksheets in XLA workbook
Darko Posted on: 31-12-1969
This all seems fine but I have created an XLA add-in that contains some worksheets with data and some VBA code.
Now, I believe since I moved to a newer version of Excel when I open XLA document I can see the VBA code there but no worksheets and I am not able to change any data.
There is no option to "unhide" anything because XLA workbook itself is hidden in Excel.
How can I get to my worksheets in the XLA in order to change the data there ?
Thanks
Unhiding worksheets in XLA workbook
Darko Posted on: 31-12-1969
I forgot to mention that sheets already have the Visible property set to -1 ie. xlSheetVisibleUnhiding worksheets in XLA workbook
Darko Posted on: 31-12-1969
I have just found an answer so I am going to answer myself.
When XLA add-in is loaded one can go to VB editor select that add-in in the project explorer and ThisWorkbook item/propety underneath and it's "isAddIn" property which can then be set to True. Immediatelly this will unhide hidden workseets belonging to this XLA in the Excel.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
