+ Reply to Thread
Results 1 to 5 of 5

opposite of XLVeryhidden!!

  1. #1
    Registered User
    Join Date
    05-30-2006
    Posts
    33

    opposite of XLVeryhidden!!

    Hi members,
    Please let me know if anybody knew the opposite of xlVeryHidden.
    I have made a sheet hidden using the below code.

    Sheets("sheet1").Visible = xlVeryHidden


    Now if want to make it visible, what is the macro to write.

    Please advice..

    Thanks

    Roshin

  2. #2
    Registered User
    Join Date
    04-21-2006
    Posts
    61
    Sheets("sheet1").Visible = xlsheetvisible

    or

    Sheets("sheet1").Visible = True
    try those...

    Quote Originally Posted by roshinpp_77
    Hi members,
    Please let me know if anybody knew the opposite of xlVeryHidden.
    I have made a sheet hidden using the below code.

    Sheets("sheet1").Visible = xlVeryHidden


    Now if want to make it visible, what is the macro to write.

    Please advice..

    Thanks

    Roshin

  3. #3
    Registered User
    Join Date
    04-21-2006
    Posts
    61
    Sheets("sheet1").Visible = xlsheetvisible

    or

    Sheets("sheet1").Visible = True
    try those...

    Quote Originally Posted by roshinpp_77
    Hi members,
    Please let me know if anybody knew the opposite of xlVeryHidden.
    I have made a sheet hidden using the below code.

    Sheets("sheet1").Visible = xlVeryHidden


    Now if want to make it visible, what is the macro to write.

    Please advice..

    Thanks

    Roshin

  4. #4
    Duncan
    Guest

    Re: opposite of XLVeryhidden!!

    Have you tried

    Sheets("sheet1").Visible = True

    Duncan


  5. #5
    Registered User
    Join Date
    05-30-2006
    Posts
    33
    Thanks Duncan...it was as so simple...




    Quote Originally Posted by Duncan
    Have you tried

    Sheets("sheet1").Visible = True

    Duncan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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