+ Reply to Thread
Results 1 to 5 of 5

Hide and unhide sheets with a password

  1. 01-25-2016, 05:20 AM #1
    Saturn is offline
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    287

    Hide and unhide sheets with a password

    Is it possible to hide and unhide sheets with a password ?
    I need to hide and unhide sheet2 and sheet4 in the enclosed workbook.
    Could anybody help me with this macro?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-25-2016, 09:22 AM #2
    Saturn is offline
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    287

    Re: Hide and unhide sheets with a password

    Any solutions, Excel-fans ?
    Reply With QuoteRegister To Reply
  3. 01-25-2016, 09:28 AM #3
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Hide and unhide sheets with a password

    One way.

    ....................
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  4. 01-25-2016, 09:31 AM #4
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,058

    Re: Hide and unhide sheets with a password

    Press button and enter Psswd for password

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Never use Merged Cells in Excel
    Reply With QuoteRegister To Reply
  5. 01-25-2016, 09:59 AM #5
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Hide and unhide sheets with a password

    Another option...
    You will find the below code on Module1 and you may click the buttons on the Sheet1 to Hide or Unhide the sheets.
    Alternatively you may Press Ctrl + Shft + H to Hide the sheets and Ctrl + Shift + U to Unhide the sheets.

    In the below code you may change the password used as per your requirement.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inputbox with password to hide/unhide specific sheets in workbook.
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 07:41 AM
  2. Hide all sheets (very hidden) except one or Unhide all sheets with password
    By wmdriver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2015, 07:21 AM
  3. Hide Selected Sheets And No Unhide Without Entering Password
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-19-2014, 11:53 PM
  4. 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
  5. Switchboard in Excel. Password to hide and unhide sheets. User form hangs
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2011, 06:27 PM
  6. hide / unhide separate sheets based on password
    By spudinsane in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-27-2011, 04:48 AM
  7. vba to hide / unhide separate sheets based on password (bis)
    By sigeg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2011, 05:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1