Making a Tab Visable

I have an old Workbook (Excel 2007) that I constructed several years ago; In addition to the tab I use to input information/data, I have a hidden tab in the workbook.  When I go to my Developer Screen, I can see the tab, but I cannot display it.  When I go into the Explorer and change the Xlsheethidden to Xlsheetvisable, it gives me a "Unable to set the visibility to the Worksheet Class" note.  Additionally, I cannot add a tab.

Any ideas on how to get it to display the tab?  Or change the restriction/setting?

B.
Bright01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dlmilleCommented:
Check to see if your workbook is protected.  I generally get the "unable to add" error if the workbook is protected.  Click right mouse on tab and see if Unprotect is an option.  Otherwise, can you upload?
0
dlmilleCommented:
Also, you can right click on a tab and see if unHide is an option.  if it is very hidden, then that won't be, but let's see what you get, first.

You can run this code to unhide all worksheets, if not protected:

 
Sub unHideAll()
Dim sht As Worksheet

    For Each sht In ActiveWorkbook.Worksheets
        sht.Visible = xlSheetVisible
    Next sht
    
End Sub

Open in new window


Dave
0
Bright01Author Commented:
Dave,

Hey.  Here is the file for you to take a look at.  I've followed your instructions but its just a strange thing.  Look at the "Master" tab in the Developer section and see if you can make it visible.

BTW:  How's our RASCI WB coming along?

Best regards,

B.
Workbench.xlsm
0
dlmilleCommented:
As I suggested, the workbook IS protected.  You need to unprotect the worksheet, first.  Right click on the Master tab, and you'll see Unprotect is an option.

It appears all the other sheets are protected as well...

Once you sort out the worksheet password, you can use the macro I put in Module 1:
Sub unHideAll()
Dim sht As Worksheet
Dim passwd As String

    passwd = "Password"

    For Each sht In ActiveWorkbook.Worksheets
        sht.Unprotect Password:=passwd
        sht.Visible = xlSheetVisible
    Next sht
    
End Sub

Open in new window


Attached is an updated version with this code embedded.

Enjoy!

Dave
Workbench.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
Dave,

Got it!  I didn't realize that the Protect Sheet didn't change if it WAS PROTECTED.  I unprotected it and got to the tabs.  Much thanks.  I'm afraid I'm going to not be able to use "Bright01" much longer if I continue to author such questions!

B.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.