+ Reply to Thread
Results 1 to 2 of 2

Help Add/Delete using forms (supervisor pwd protected access)

  1. #1
    Registered User
    Join Date
    04-17-2005
    Posts
    1

    Exclamation Help Add/Delete using forms (supervisor pwd protected access)

    I need some help using Forms and Excel macros. I'd like to write macros to add and delete people from the list and then automatically update the drop-down box to reflect the changes. Then also put the list in alphabetical order and correctly number the list so I can then use VLOOKUP as shown in the attached sheet. Also, would like to somehow password protect the macro so only supervisors can do these tasks. Does not need to be an ultra secure password protection, could even be a hard coded passwork listed in the macro that uses a MsgBox to ask the supervisor to enter the pwd.
    Thanks,
    Brett
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Brett,

    I modified your code to include the macros to do want you wanted. After you password protect the worksheet, the Add and Delete buttons display a message telling you this and do nothing. The names are sorted when added. The attached file (Zipped) is your workbook complete with macros. If have any questions or problems, contact me via e-mail at [email protected].

    Password Protecting a Worksheet:
    1) On the Excel menu select Tools.
    2) Select Protection from the list.
    3) Select Protect Sheet... from the Pop Up menu.
    4) Follow the directions to Password protect the worksheet.

    Sincerely,
    Leith Ross
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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