Unhiding worksheets
"Hiding Worksheet" and "Unhiding Worksheet" are both greyed out. Sheets are not protected. Any suggestions as to why this is. Thanks, Chris
Hi,
Welcome to the forum, if there are no hidden sheets then they are greyed out
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Workbook protected?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Hi. No the workbook has been opened to allow edits. Chris
Both "Unhide" ands "Hide" are greyed out and I have unprotected all visible worksheets. Chris
If you are sure there are worksheets, they are probably "very hidden" you will need to use VBA to unhide them. Do you know the names of these worksheets?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Chris, you can edit a protected workbook. Is the workbook protected?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 2 users browsing this thread. (0 members and 2 guests)
Posting Permissions
Reply With Quote
Bookmarks