how to make Hidden sheet visible
how to make Hidden sheet visible
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: how to make Hidden sheet visible

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have an excel workbook from a former employee which when you start the xls it performs a macro to make an extra menu
    the menu is being build from a worksheet where all the info is like name of submenu's face id's, i know this caase he told me that before he left.now i must change the menu so i thougt to change the sheet but i can't find it anywhere not when i use unhide .
    when i use the vba editor there is a workbook with two sheets for example a sheet called menu and a sheet called info but neither one of them is visible in my workbook.

    who can help me with this problem?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Look under the Format | Sheet menu command to see if Unhide isn't "ghosted".

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No that's all normal.
    in the vba editor i see there are 2 sheets but when i click on them , the view object button is greyed out and can't be chosen.
    normally when you click on a sheet and select the view object button then the sheet is presented to you.

    so i see 2 sheets in the vba editor but i can't see them anywhere.

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-01 12:05, Herman wrote:
    No that's all normal.
    in the vba editor i see there are 2 sheets but when i click on them , the view object button is greyed out and can't be chosen.
    normally when you click on a sheet and select the view object button then the sheet is presented to you.

    so i see 2 sheets in the vba editor but i can't see them anywhere.
    Thats because the Sheets visible property is
    set to Xlsheetveryhidden.
    Goto the sheets properties F4
    Scroll down until you see visible
    Change this property here to xlsheetvisible


    Ivan

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That's when you have a normal xls
    but this one is an xla(addin)
    i know the password for the xla otherwise i couldn't see the vba code
    but when i want to set the properties is xla to no then it asks me again for a password
    and then the password i used to open the vba editor isn't good anymore.

    sorry for not mentioning that it all goes about an xla file

  6. #6
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried just opening the .xla file?

    *.xla's are usually found somewhere in the directory:


    C:Program FilesMicrosoft OfficeOfficeLibrary


    If you browse to this location or search for the xla in question, just double click on it and
    open it up. So long as you know the password you should be able to do whatever you want to it.

    _________________
    [b] Mark O'Brien

    [ This Message was edited by: Mark O'Brien on 2002-03-01 12:51 ]

  7. #7
    Guest

    Default

    Yes i have opened the xla and can view the code but i can't still use the option isaddin
    and set it to no, then it asks for a password
    .

    and when i can't do that then i can't take a look at the sheets in the workbook

    i cansee al modules forms etc.. and i can change them but the only thing i can't is et the isaddin option to false then there is a messagebox and asks me for a password

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Anybody has a clue about previous discussed problem

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't know if this will work in your case but try this.

    Enter the following code in a standard module.
    Run it from the VBE with the Immediate window open.
    All the sheets in the workbook whether hidden or not will be listed in the Immediate window.
    (If you already know the names skip this part)

    Public Sub ListSheets()
    Dim varsheet As Variant
    For Each varsheet In Sheets
    Debug.Print varsheet.Name
    Next varsheet

    End Sub


    Enter the following code in the same module.
    Replace SHEET NAME with the name of the sheet you want to unhide.
    Run the code.
    The “Very Hidden” sheet will appear.

    Public Sub ShowSheet()
    Application.Worksheets("SHEET NAME").Visible = xlSheetVisible

    End Sub

    Good luck

    [ This Message was edited by: GeorgeB on 2002-03-03 07:25 ]

  10. #10
    New Member
    Join Date
    Feb 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    This doesn't work it look likes the workbook in the xla is also password protected, i unprotect the xla because i know the password but
    if i want to set the workbook to isaddin no then it asks again for a password, the original password for the xla doesn't work.

    greetings herman

User Tag List

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