| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable change only with Form?
I am using a UserForm to populate fields in a worksheet. The user fills in
the fields in the Form and clicks the Enter Data button; the information is then transferred to the next available row in the sheet. I'd like to protect the data from being able to be changed unless the user opens a separate Edit Data Form. What would be the best way to accomplish this? Through the SheetChange event? Some setting of protection? What would you recommend? Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable and enable dropdown combobox(Form Control) | Excel Discussion (Misc queries) | |||
| How can I call a macro or form. in the moment that enable any shee | Excel Worksheet Functions | |||
| how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
| Form Colors on a form change on a laptop pc | New Users to Excel | |||
| How do i enable a function to change other cells? | Excel Programming | |||
Threaded Mode
