LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I force user to enter their ID# before filling other data?

I am setting up a worksheet to help our staff calculate customer transaction
costs. I want to prevent the staff from entering any data into the worksheet
until they have entered their employee ID in the employee ID cell. In other
words, I want all other data entry cells to remain locked until the person
filling out the worksheet has typed in his or her employee ID.

Thank you for your help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i force users to first enter data in one cell before anythi des-sa[_2_] Excel Discussion (Misc queries) 2 June 3rd 08 10:29 PM
data validation list: how do i 'force' a user to enter data from the list? showsomeidnow Excel Discussion (Misc queries) 4 May 1st 07 05:49 PM
data validation list: how do i 'force' a user to enter data from the list? showsomeidnow Excel Discussion (Misc queries) 2 April 29th 07 11:09 PM
Force user to enter data in cell before moving to next cell Fusionmags New Users to Excel 3 November 19th 06 11:49 PM
Excel: Filling a user form with yesterday's data randallwilkins Excel Programming 2 June 3rd 06 04:09 AM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"