+ Reply to Thread
Results 1 to 2 of 2

Create A Form With Password Protected Data

  1. #1
    Registered User
    Join Date

    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.


  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2010

    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


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