+ Reply to Thread
Results 1 to 9 of 9

Splash Page With Username and/or Password Protected Sheets

  1. #1
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    305

    Splash Page With Username and/or Password Protected Sheets

    I'm wanting to create a workbook that has a splash page and multiple hidden (or very hidden... I don't know the difference) worksheets. From the splash page, I'd like users to be able to click a button to "enter" their portion of the workbook. I'm thinking when they click the button, they would be prompted to enter username and/or password. Depending on what they enter, specific sheets would be made visible for them to utilize, make edits, etc.

    If I need to make a dummy workbook for an example, let me know. But for the sake of this post, Sheet 1 could contain the splash page and Sheets 2 & 3 could be the two hidden Sheets for 1 user to access. I think if someone can make that one example, I could expand on it to suit my needs.

  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
    5,541

    Re: Splash Page With Username and/or Password Protected Sheets

    UserForm code:

    Please Login or Register  to view this content.

    ThisWorkbook code :

    Please Login or Register  to view this content.
    The attached sample project has password protected sheets of which I do not have the password. Sorry.
    You will need to use the code in your own project, but alot of the attached can be copied and pasted.

    The initial password code for the splash screen is : Username Dave1 Password dave1
    Attached Files Attached Files

  3. #3
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    305
    Sorry for the delayed response but my job duties have pulled me away from my Excel play time. I will try this once I'm able to get a free moment. Thanks for the assistance!

    Quote Originally Posted by Logit View Post
    UserForm code:

    Please Login or Register  to view this content.

    ThisWorkbook code :

    Please Login or Register  to view this content.
    The attached sample project has password protected sheets of which I do not have the password. Sorry.
    You will need to use the code in your own project, but alot of the attached can be copied and pasted.

    The initial password code for the splash screen is : Username Dave1 Password dave1

  4. #4
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    305

    Re: Splash Page With Username and/or Password Protected Sheets

    I wasn't able to get this work for me. It operates fine but I need something where I can build off of it. I need VBA for dummies... haha.

    I've attached a simple workbook here that shows the way I need it laid out. If you can add the code to this example, I'm pretty confident that I can expand it to suit my needs.

    Can you or anyone help with this one?
    Attached Files Attached Files

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

    Re: Splash Page With Username and/or Password Protected Sheets

    Did you get an answer to your project ?

  6. #6
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    305
    Quote Originally Posted by Logit View Post
    Did you get an answer to your project ?
    Yes and no... no one replied directly to me here, as you can see but I actually found an older post via Google (go figure... Google knows everything!) and the thread was closed but I sent a private message to the person that solved the request and he was able to provide me with an example workbook that is customizable. It's nearly perfect for me. Did you have an answer also or were you looking for the same thing?

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

    Re: Splash Page With Username and/or Password Protected Sheets

    I put together a couple of examples, and thought if you hadn't found anything I would share with you.

  8. #8
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    305
    Quote Originally Posted by Logit View Post
    I put together a couple of examples, and thought if you hadn't found anything I would share with you.
    I wouldn't mind seeing them. Would you upload them for me to see? I could share this other with you also. Maybe it would benefit you, as well. I'm on my mobile device now but will be available again tomorrow.

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

    Re: Splash Page With Username and/or Password Protected Sheets

    Going to send you a private message ...

+ 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. Unhide sheets with username/password match entered
    By sporenta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2014, 03:16 PM
  2. VBA to get password protected web page data
    By sixthscroll in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2013, 07:43 PM
  3. Macro for importing username/password protected web data
    By hasanqz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2013, 07:29 PM
  4. [SOLVED] Username and Password Form - Show Username in Sheet
    By ryan180 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2013, 07:06 PM
  5. Web Query from Logon and password protected web page
    By Taislin in forum Excel General
    Replies: 2
    Last Post: 06-26-2012, 11:43 AM
  6. 2010 Web Query on password protected page errors
    By forrie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2012, 09:15 PM
  7. [SOLVED] password protected page not opening by web query
    By vive2567 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2006, 11:25 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