On Sat, 24 Jan 2004 21:04:36 -0600, Rockee052
wrote:

Hello All,

I have a UserForm that inputs an employees name and wage into select
rows and columns. The problem I am running into is that some employees
iare inputing the data manually and not using the userform, which 90%
of the time result in inaccurate wage and spelling of names. Is there a
way to lock certain cells for userform use only?? Some info has to be
entered manually but, the names and wages don't.

The only way that I can think of is to password protect the data entry
sheet (after unlocking the cells that will need manual entry), then
have the user form unprotect the worksheet as it needs to enter data.

Ensure that the form's ShowModal property is True (so that the users
can't get at the sheet while the form is open), and put code to relock
the sheet in the UserForm_QueryClose event procedure.

Post again if you aren't sure how to do any of this.

---------------------------------------------------------
Hank Scorpio
- Yes, yes, I know I've been missing for a while. Long story. And don't
ask what the size of my inbox is at the moment either... 8^
scorpionet who hates spam is at iprimus.com.au (You know what to do.)