Consulting

Results 1 to 4 of 4

Thread: Unable to set the Visible property of the Worksheet class

  1. #1
    VBAX Mentor
    Joined
    May 2010
    Location
    London
    Posts
    307
    Location

    Unable to set the Visible property of the Worksheet class

    Dear All ,

    I have a spreadsheet in Excel 2007. Some worksheets are hidden. Hide/Unhide options are greyed out. I tried to make them visible from VBA Project/Properties by changing the visible option to 1. However it gives an error message saying "Unable to set the Visible property of the Worksheet class" I've found out that workbook protection would cause this error. However the workbook is not protected. Visible tabs had a worksheet protection and I made them unprotected. Apart from that there isn't any password protection. I really don't know what the problem is, your help would be much appreciated..

    Regards,
    Yeliz

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    Try -1

    Paul

  3. #3
    VBAX Mentor
    Joined
    May 2010
    Location
    London
    Posts
    307
    Location

    Unable to set the Visible property of the Worksheet class

    Hi Paul ..

    Thanks for your respond. Visible options are -1/0/2. I've already tried -1, (sorry it was my mistake, I should have said -1 instead of 1). It doesn't let me change the option from 0 to -1 and the error message pops up saying Unable to set the Visible property of the Worksheet class..

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Post the workbook.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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