+ Reply to Thread
Results 1 to 4 of 4

Hidden sheet - password

  1. #1
    Registered User
    Join Date
    03-05-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    32

    Hidden sheet - password

    Hi All,

    I'm struggling with figuring out the code to hide one sheet and have it password protected. Basically I need it to be hidden each time the user opens the workbook, but if he clicks "unhide" and selects the certain sheet, I want him to enter a password. Then, after closing the workbook I want it to get back to hidden mode automatically. Is there a way to do it? Thank you!
    Last edited by kf1511; 05-25-2022 at 11:32 AM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Hidden sheet - password

    Here is one method :

    Please Login or Register  to view this content.
    The password is : open

    You can set the sheet or sheets to be hidden and then opened with the password by changing the code. No matter what the user does, the
    specified sheet/s will be hidden when the workbook is opened and automatically hidden again when the workbook is closed.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-05-2021
    Location
    Poland
    MS-Off Ver
    365
    Posts
    32

    Re: Hidden sheet - password

    Works perfectly!!!!! Thank you so much!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Hidden sheet - password

    You are welcome.

+ 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. Password Protecting Hidden Sheet
    By koochandkai in forum Excel General
    Replies: 1
    Last Post: 07-02-2016, 09:00 AM
  3. [SOLVED] Excel Hidden sheet with password
    By forward in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-03-2016, 12:17 AM
  4. Electronic signature with password from hidden sheet and pdf final sheet only
    By anthonybarnard in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-11-2016, 04:13 PM
  5. [SOLVED] Password Protecting a Hidden Sheet
    By JRose0303 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2014, 12:30 PM
  6. password hidden sheet
    By nieuwwerk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2010, 11:33 AM
  7. Hidden Sheet with Password
    By gabch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2006, 12:01 PM

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