Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Making a Tab Visable

Posted on 2011-10-04
5
Medium Priority
?
353 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Bright01
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:dlmille
ID: 36914277
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
 
LVL 42

Expert Comment

by:dlmille
ID: 36914283
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
 

Author Comment

by:Bright01
ID: 36914490
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
 
LVL 42

Accepted Solution

by:
dlmille earned 2000 total points
ID: 36914632
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
 

Author Closing Comment

by:Bright01
ID: 36914705
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question