Microsoft Excel - Missing tab sheets in excel?

Asked By david on 24-Apr-13 03:50 AM
Hi

I have an Excel work book with several tab sheets, i hid a number of tabs and protected the sheet but since then im unable to unhide the sheets? The sheet is now unprotected.

Im familiar with the process but the unhide options are greyed out, i have also tried the VBA route with VBA project list (all the sheets are showing here) but unable to unhide through the properties?

any help on this is much appreciated as I'm at a total loss


Regards
Harry Boughen replied to david on 25-Apr-13 04:17 PM
Hello David,
Are you sure that you have selected sheets either side of the hidden ones by selecting one then hold down shift and select the other one.  Then Format,Sheet,Unhide. It should then give you a dialog box with a list of the hidden sheets from which you can select the one to unhide.
There is an option called VeryHidden but I think that is only available through VBA so that is unlikely to be a factor.
Hope this helps
Harry
david replied to Harry Boughen on 26-Apr-13 03:37 AM
end of post
david replied to Harry Boughen on 26-Apr-13 03:57 AM
Price calculator Rev 5 copy.zip
Price Calculator Rev 3.Windows 2010 Only. xlsx.zip

Harry

Attached are my files, note i have currently checked the hide sheet tabs in the options but 3 tabs will show titled Price calculator, Quotation and Selection, if unchecked the tabs will show okay. it is the other tabs that i cannot unhide.

There are also hidden tabs that a cannot unhide you will see the list of all tabs in the VBA project list.

Also with regards my other  question id like to create a toggle button  (refresh button currently shown on the on the Selection tab/page) within the Rev 5 copy so this is workable on a mac with office 2011, as shown on the windows 2010 copy. this works okay in this file for windows 2010 excel but not in 2011mac version.  The toggle button simple refreshes the drop down options so that the cells are black ready for re selection from scratch. 

Regards David
Harry Boughen replied to Harry Boughen on 29-Apr-13 11:28 PM
Hello David,
Sorry to take a while to get back.  Been a bit busy.  I notice that the Workbook is protected.  I think that would be having an effect but whether that is the whole problem I don't know.  Will try to get back to it as soon as I can.
Regards
Harry
Harry Boughen replied to david on 01-May-13 02:56 AM
Hello again David,
Open your workbook.  Then go to File, Options, Advanced and scroll down to Display Options for this workbook and check the Show sheet tabs check box.
That seems to fix it provided that the sheet visible property if set to true.
Regards
Harry
david replied to Harry Boughen on 01-May-13 04:42 AM
Harry

I do note what you say but it is the other tabs i need to unhide, in the VBA project list it shows all the tabs and when i go into properties for each tab it will not allow me to change to Visible option to sheet visible, it is currently set at sheet Hidden?

Regards
 David
Harry Boughen replied to david on 01-May-13 05:26 AM
Hi David,
Here is your file back.  As near as I can see, all tabs are available.
Price Calculator Rev 3.Windows 2010 Only. xlsx.xlsx.zip
Regards
Harry
david replied to Harry Boughen on 01-May-13 06:59 AM
Harry

That is great what did you do to get them all showing? Can you do the same with the other file for me

Many thanks

david
Harry Boughen replied to david on 01-May-13 07:14 AM
Hi David,
Price calculator Rev 5 copy.zip
Just went through VBA editor and set visible property to visible and changed the sheet tab status through Options.
Regards
Harry
david replied to Harry Boughen on 03-May-13 04:00 AM
Harry

thanks for getting my tabs back. I tried what you did but when i tried changing the properties from hidden to visible i was getting the message 'unable to change properties' 
Harry Boughen replied to david on 03-May-13 04:09 AM
Hello David,
Are you sure that you have unprotected the workbook?
Regards
Harry
david replied to Harry Boughen on 03-May-13 07:56 AM
Harry

i do assume so, due to the option being available to 'protect' the sheet rather than the option to 'unprotect' the sheet.

also you have corrected it for me now showing all  tabs without you having to unprotect anything?

david
Harry Boughen replied to david on 03-May-13 08:10 AM
Hi David,
I'm struggling to remember now but I vaguely recall that the workbook (not just worksheets) might have been protected for the first one at least.  But I certainly don't recall having to unprotect the second one as I only looked at that one after you asked after it.
I might just go back to you original posting and download them again to see if it was the case.
Regards
Harry