+ Reply to Thread
Results 1 to 3 of 3

Unhide a sheet with a password

  1. #1
    Registered User
    Join Date
    10-24-2020
    Location
    Dubai
    MS-Off Ver
    2016
    Posts
    32

    Unhide a sheet with a password

    Hi all
    Can anyone help me out? I’m trying to get a macro vba code for unhiding a sheet with a password. For example I have three sheets in a workbook. Sheet1 & Sheet2 is available for the user but Sheet3 is hidden. (It was hidden by using the right click on tab options on sheet3 and clicking on hide). But to unhide sheet3 in the same way and see what is in it, the user has to enter the password “xxx”

    I would appreciate your help.
    Thank you

  2. #2
    Registered User
    Join Date
    03-18-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    7

    Re: Unhide a sheet with a password

    A little fine tuning may be needed here I will enter this code into worksheet activate event of sheet 3


    Private Sub Worksheet_Activate()
    Dim get_pass
    If Worksheets("Sheet3").Visible = True Then
    get_pass = InputBox("Enter Password")

    If get_pass <> "xxx" Then
    MsgBox "Incorrect Password"
    Worksheets("Sheet3").Visible = False
    End If
    End If



    End Sub

  3. #3
    Registered User
    Join Date
    10-24-2020
    Location
    Dubai
    MS-Off Ver
    2016
    Posts
    32

    Re: Unhide a sheet with a password

    Hi...

    I tried it.
    I think this will be ok.
    It's not what i was expecting but i can work around it.

    Thank you...i appreciate it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform to enter password to unhide very hidden sheet
    By dori2o in forum Excel General
    Replies: 4
    Last Post: 01-25-2018, 09:51 AM
  2. [SOLVED] Toggle Button to Unlock Sheet with Set Password and Unhide Rows and Relock Sheet
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2014, 06:16 PM
  3. Unhide password protected sheet
    By sac0011 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 02:57 AM
  4. Unhide password protected sheet
    By sac0011 in forum Excel General
    Replies: 1
    Last Post: 03-11-2014, 02:51 AM
  5. VBA to Unprotect (w/ password), Unhide, Hide, and Protect (w/ password)
    By pger34 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-14-2012, 12:35 PM
  6. [SOLVED] COmmand button requiring password, if password ok, unhide sheet.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2012, 09:43 AM
  7. Password to unhide sheets
    By lfhomet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2009, 06:58 AM

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