+ Reply to Thread
Results 1 to 1 of 1

Vehicle Sign Out Log - Auto Save, Auto Date & Time

  1. #1
    Registered User
    Join Date
    04-04-2011
    Location
    stafford, va
    MS-Off Ver
    Excel 2007
    Posts
    4

    Vehicle Sign Out Log - Auto Save, Auto Date & Time

    I am a REAL novice at this and am asking for your kind assistance in getting this going.
    I've created a vehicle sign out log (as shown below).
    1. Column "B" is where student will select their names (simple drop down menu);
    2. Column "C" is where the student will enter their driver's license info.;
    3. Column "D" is where the student will enter their destination;
    4. Column "E", I was able to copy a code from this forum where the date is automatically entered triggered by Column "B";
    4a. Can Column F be programmed to auto enter time, too?
    5. Column "A" is where the student will enter the vehicle # which is provided by the guard-on-duty once columns B, C, D, E and F are filled.
    This is where my hiccups are and would like the spreadsheet to work as follows:

    During vehicle check-out:
    1. Auto Save the workbook when closing (without the need for the user to save) once Columns A - E are filled;
    2. Auto Lock the filled cells (A - E) before closing to prevent anyone from deleting entered information; Keep Columns G & H unlocked for vehicle turn-in.

    During vehicle turn-in:
    1. The user/student enters the date and time in Columns G & H (hopefully we can do an auto time entry also when "G" is filled). Then,
    2. Auto Lock the completed columns to prevent tampering.

    I hope I'm making sense!

    Thank you in advance.

    Claudee
    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)

Similar Threads

  1. macro to bring up stored workbook, auto save to a new folder, then auto fill
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 06:58 PM
  2. Complex VBA problem auto insert date and time, auto insert comment, etc.
    By rojashan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 09:40 PM
  3. Auto Sort, Auto Lock, Auto Date & Time Stamp
    By suehatesyou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2010, 02:57 PM
  4. [SOLVED] How to AUTO SAVE as opposed to turning on auto recovery: EXCEL
    By T-mo in forum Excel General
    Replies: 1
    Last Post: 01-12-2006, 06:20 PM
  5. [SOLVED] Auto Excel workbook close: save= false during an auto subroutine
    By tomwashere2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-16-2005, 02:05 AM

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