Page 1 of 2 12 LastLast
Results 1 to 10 of 11

unlocking vba so I can unhide sheet

This is a discussion on unlocking vba so I can unhide sheet within the Excel Questions forums, part of the Question Forums category; How do I unlock VBA code so I can unhide sheet. Or is there a way to just unhide the ...

  1. #1
    Board Regular
    Join Date
    Oct 2002
    Posts
    840

    Default unlocking vba so I can unhide sheet

    How do I unlock VBA code so I can unhide sheet.
    Or is there a way to just unhide the sheet?

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,945

    Default

    depends how the workbook / sheets have been protected / how the sheet was hidden in the first place - more details please...

  3. #3
    Board Regular
    Join Date
    Oct 2002
    Posts
    840

    Default Re: unlocking vba so I can unhide sheet

    I only know of one way of hiding worksheet that is in vba area where you can set properties of sheet.
    Would it be better if I hide columns and protect worksheet, or is there another way to hideworksheet?

  4. #4
    Board Regular
    Join Date
    Jan 2004
    Posts
    146

    Default Re: unlocking vba so I can unhide sheet

    Set the visible propery Of the sheet to 2-Xlvery Hidden from 0-Xl Visisble

    lock Ur VBA project by giving a Password

    Protect ur Workbook


    For Unlocking the VBA password U must know the password .

    If u forgor buy a software from www.elmsoft,com
    or (coslty one)
    Passware KIT 6.1


    They will open the VBA password

    It will sove ur problem

    I think


    Regards


    kamal

  5. #5
    Board Regular
    Join Date
    Oct 2002
    Posts
    840

    Default Re: unlocking vba so I can unhide sheet

    I am really sorry but I am confused as to how I would unhide after I do this.

  6. #6
    Board Regular
    Join Date
    Oct 2002
    Posts
    840

    Default Re: unlocking vba so I can unhide sheet

    I take it back whatever you did it worked.

  7. #7
    Board Regular
    Join Date
    Oct 2002
    Posts
    840

    Default Re: unlocking vba so I can unhide sheet

    Sorry left off thanks.
    Thanks!

  8. #8
    Board Regular
    Join Date
    Jan 2004
    Posts
    146

    Default Re: unlocking vba so I can unhide sheet

    After Unlocking The VBa Project
    U will be in the Visual Basic Editor

    Select the the sheet u want to unhide

    see its properties

    set the visible property of the sheet to Visible from Xlvery hidden ( from 2 to ) The shhet will be visible

    before doing this u have to unprotect the workbook an dthe that specific worksheet if u do without unprotecting the workbook u will get and error


    Thanks


    Reagards

    kamal

  9. #9
    Board Regular
    Join Date
    Oct 2002
    Posts
    840

    Default Re: unlocking vba so I can unhide sheet

    This works perfectly but how do I use VBA to hide very hidden?

  10. #10
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202

    Default Re: unlocking vba so I can unhide sheet

    Sheets("HideMe").Visible = xlVeryHidden

Page 1 of 2 12 LastLast

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