+ Reply to Thread
Results 1 to 2 of 2

Create A Form With Password Protected Data

  1. #1
    Registered User
    Join Date
    06-01-2014
    Posts
    79

    Create A Form With Password Protected Data

    Hi ,
    I want to create a simple form for employees to enter their number of hours worked for the day. Driver name, Start Time, Finish Time and date. I need this information to populate an excel spreadsheet but I don't want the employees to be able to view the data that is being put in. Also possibly throw an error if the same employee accidentally enters their information twice.

    Thanks

  2. #2
    Forum Contributor
    Join Date
    01-25-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    434

    Re: Create A Form With Password Protected Data

    how about using a web form for them to input hours to ?

    Input Hours -> https://docs.google.com/forms/d/1hvp...w91Us/viewform

    Sheet that displays results -> https://docs.google.com/spreadsheets...gid=1959723821

    Excel can import the data through a web connection, can be auto-refreshing, or refreshed manually

    If you think this could work for you, it would just need some code to go through the data collected, like if you have a list of employees get it to check that a response has been received by all for dates required.
    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. Replies: 0
    Last Post: 05-19-2014, 10:02 PM
  2. Password dialog keeps opening after closing form in protected vba project
    By bkrose120 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2013, 03:24 AM
  3. Password Form with protected sheet
    By jeck in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-03-2011, 11:04 AM
  4. Create Query from Password Protected Workbook
    By Joy C in forum Excel General
    Replies: 0
    Last Post: 03-25-2011, 05:46 AM
  5. password-protected form
    By robindemey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2010, 02:53 AM

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