+ Reply to Thread
Results 1 to 5 of 5

Making Very Hidden Tabs Visible

  1. #1
    Registered User
    Join Date
    10-01-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    6

    Making Very Hidden Tabs Visible

    I am trying open very hidden tabs in a spreadsheet that someone else has sent me.

    In the VBA screen, I've tried just selecting the tabs to be visible but get the following error message.

    "Unable to set the Visible property of the Worksheet class".

    I've also tried running the following code but still doesn't appear to work.
    Please Login or Register  to view this content.
    Does anyone have any suggestions? Under "File", it does say that "A password is required to open this workbook" so not sure if that's related.

    Thanks.
    Last edited by jeffreybrown; 02-11-2019 at 07:02 PM. Reason: Please use code tags!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Making Very Hidden Tabs Visible

    Nothing is wrong with the code, so yes, there is a password.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    10-01-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Making Very Hidden Tabs Visible

    Quote Originally Posted by jeffreybrown View Post
    Nothing is wrong with the code, so yes, there is a password.
    Thanks for the quick response. If the structure of the workbook has been protected, would that affect my ability to make the very hidden tabs visible as well?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Making Very Hidden Tabs Visible

    Yes, that would prevent you from unhiding a sheet also.

  5. #5
    Registered User
    Join Date
    10-01-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Making Very Hidden Tabs Visible

    Quote Originally Posted by jeffreybrown View Post
    Yes, that would prevent you from unhiding a sheet also.
    Understood, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.
    By jexcelio in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2016, 02:42 AM
  2. [SOLVED] Format all cells in all sheets to Protection Hidden on visible and hidden tabs
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2014, 03:17 PM
  3. Making sheets visible or hidden based on value of a range of cells.
    By alzhander in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2012, 09:12 AM
  4. Making a Hidden App Visible
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2011, 06:57 PM
  5. Making hidden graphs visible or removing
    By Nodak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2005, 07:06 AM
  6. Making sheets visible and hidden to users
    By Xlyr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2005, 04:06 PM
  7. [SOLVED] Making sheets visible / hidden
    By Xlyr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1