I am viewing a workbook that displays 3 worksheets but in VBA I can see 6 worksheets. Right-clicking a tab does not allow worksheets to be unhidden. There does not appear to be any code that is hiding these worksheets? What am I missing?
Thanks in advance
They are already hidden, not by code, by sheet parameters.
From the sheets (not VBA), right-click on a sheet tab you CAN see and select UNHIDE to see a list of hidden sheets.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
The sheets are probably very hidden in their Visible property. This can only be changed in the VB Editor. Select the sheet in the VBE & scroll down to the Visible property, change it to "-1 - xlSheetVisible"
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks Roy. When I try that I get the following message: Unable to set the Visible property of the Worksheet class?
The workbook is not locked or password protected and I can't figure this one out? Right-clicking on a sheet tab you CAN see, the UNHIDE option is greyed out?
Maybe it's corrupted. Can you attach it?
Once again, thanks for your time Roy. The file does not appear to be corrupt. Unfortunately, I can't attach the file as it contains sensitive financial data. I will continue trying and will revert if I am successful.
If I right-click a sheet tab that I CAN see, only the following options are NOT greyed out: View Code, Protect Sheet and Select All Sheets. I can't hide a sheet that I CAN see?
It appears as though the workbook is protected! I am trying to locate the password & that should resolve the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks