Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Workbook access control

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    East Texas
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Is there a way to have a workbook ask for a password after it has been accessed more than 3 times? If the correct password is entered then the userform will display and if not then the workbook will close. And if so how would you go about doing this.

    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes
    Store your workbook open count in some inconspicuous cell and increment it every time the work book is opened. If it >=3 then prompt for the password.
    On workbooks such as these, I hide all of my sheets except one which has no use except to display a simple message "macros must be enabled to use this workbook", if the correct password is supplied, the sheets are all unhidden and available for use.
    Tom

    [ This Message was edited by: TsTom on 2002-04-11 11:28 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •