shampouya
asked on
How to unhide sheets in Excel 2010
I know this sounds like a super basic question, but for the life of me I cannot figure out where 2 out of 6 of my sheets are within my workbook. Normally I can right-click the tabs and unhide, but Excel is telling me there is nothing to unhide. Meanwhile, the worksheets.count function in VBA is telling me that there are 6 sheets in the file, even though I can only see 4 sheets. The file has no password protection. If worksheets(1).activate is run, then all the tabs that I can see are suddenly unselected. Where could those 2 secret sheets possible be?
John
Right click on one sheet and Select All Sheets. Then scroll the sheets from left to right and right to left (are they scrolled off the sheet bar?)
ASKER
No luck, the sheet names are rather short, so scrolling isn't crowding any of them out of view.
I really do not know why you can only see 4 sheets if there are 6 there and none hidden.
What happens if you try to move the sheets around (re-order them). Is one hidden underneath?
What happens if you try to move the sheets around (re-order them). Is one hidden underneath?
ASKER
No luck there either; those first 2 sheets are still not visible. Sheets(3).activate works fine though.
Another thing you might try is to copy the workbook to a USB key, take it to a different computer and try on the different computer.
Just throwing out a guess here, but after Select All Sheets can you then do an Unhide?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great answers, thanks guys