form

  • Thread starter Thread starter a
  • Start date Start date
A

a

I use form to input information into several columns on a
spreadsheet. I will be letting other people input and I
would like to lock the sheet so information can only be
entered thru the input form. How can I do this?

Thanks you in advance
 
one simple way is to set sheet protection ON (make sure
that all cells you wish to protect are locked when
protection is on). When the user has finished entering
data into the UserForm and (probably?) clicks the "OK"
button, the code associated with that click would
unprotect the target sheet, write the data to the sheet
and then protect the sheet. If you are concerned abut
casual data entry, no password for sheet protection is
required. If you are concerned about people trying to get
around the portection, then use sheet protection with a
password. If the latter, then your VBA project should be
password protected too.
 
Back
Top