Results 1 to 8 of 8

Unable to set visible property of worksheet Class

This is a discussion on Unable to set visible property of worksheet Class within the Excel Questions forums, part of the Question Forums category; Hi, i have a very hidden worksheet but when i try to change to visible i get message Uanable to ...

  1. #1
    Board Regular Emmily's Avatar
    Join Date
    Oct 2008
    Location
    Sydney
    Posts
    656

    Default Unable to set visible property of worksheet Class

    Hi, i have a very hidden worksheet but when i try to change to visible i get message

    Uanable to set visible property of worksheet Class

    What can i do?

  2. #2
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Glasgow, Scotland
    Posts
    6,292

    Default Re: Unable to set visible property of worksheet Class

    How are you trying to make it visible?

  3. #3
    Board Regular Emmily's Avatar
    Join Date
    Oct 2008
    Location
    Sydney
    Posts
    656

    Default Re: Unable to set visible property of worksheet Class

    Quote Originally Posted by dave3009 View Post
    How are you trying to make it visible?
    via VB editor, through properties

  4. #4
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Glasgow, Scotland
    Posts
    6,292

    Default Re: Unable to set visible property of worksheet Class

    Do the other sheets have code that hides them before this one becomes visible. You must always have one sheet visible

  5. #5
    Board Regular Emmily's Avatar
    Join Date
    Oct 2008
    Location
    Sydney
    Posts
    656

    Default Re: Unable to set visible property of worksheet Class

    i have sheet2 visible, so not sure why sheet1 cant be visible

  6. #6
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Glasgow, Scotland
    Posts
    6,292

    Default Re: Unable to set visible property of worksheet Class

    Is there any setting of sheet visibility within either sheets Activate/Deactivate routines? That seems to cause an error this end

  7. #7
    Board Regular Emmily's Avatar
    Join Date
    Oct 2008
    Location
    Sydney
    Posts
    656

    Default Re: Unable to set visible property of worksheet Class

    ok i figured it out, if a workbook is protected and a sheet is very hidden you have to unprotect the whole workbook then set to visible.

  8. #8
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,767

    Default Re: Unable to set visible property of worksheet Class

    Hi,

    Just passing by to show my wife how this forum works.
    Your workbook might be protected!?

    kind regards,
    Erik

    EDIT: you found out

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com