Results 1 to 4 of 4

Show/hide sheets on file open based on user password

Threaded View

allar Show/hide sheets on file open... 12-09-2011, 06:35 PM
john55 Re: Show/hide sheets on file... 12-10-2011, 03:49 AM
allar Re: Show/hide sheets on file... 12-10-2011, 09:03 AM
john55 Re: Show/hide sheets on file... 12-10-2011, 12:41 PM
  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    2

    Show/hide sheets on file open based on user password

    Hello. There are several discussions about that topic but I'm not able to get my whole idea working based on these (some really good) peaces of knowledge. So I decided to ask help here.

    I am trying to have an excel workbook after opening to show only certain sheets for one user, some other sheets for second user and so on. This is not based on security need, but for convenience and to prevent accidental mistakes:

    - On open the workbook should show only one sheet (Login sheet) and a userform for inserting the users password.
    - This userform should check from the data set in another hidden worksheet, if the entered password is valid. This hidden sheet contains all users UserNames, Passwords and SheetNames (multiple sheets for each user), that are to be shown when the user enters his password.
    - On closing all the sheets, except Login sheet, must get "very hidden" again.

    Hope I made my wishes understandable.

    Any help and guidance would be greatly appreciated. Thanks!
    Last edited by allar; 12-10-2011 at 03:43 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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