Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
only edit from userform
Is it possible to make a worksheet only editable from the user form?
I want to stop people editing directly because they keep entering stuff incorrectly. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
only edit from userform
Protect the sheet with the UserInterFaceOnly:=true parameter which allows
your code to update a protected sheet with locked cells. Prior to that, lock all the cells and protect the sheet. In xl2002/3 disallow user selection of any cells. In earlier versions set the EnableSelection property of sheet to xlNoSelection. Of course you will have to evaluate this advice in terms of the functionality you want to offer the user in terms of use of the worksheet. An alternative approach might be the Application.Interactive property. See the help for details. -- Regards, Tom Ogilvy "mg_sv_r" wrote: Is it possible to make a worksheet only editable from the user form? I want to stop people editing directly because they keep entering stuff incorrectly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit exsisting data with userform | Excel Discussion (Misc queries) | |||
How do you edit the text in a userform-textbox? | Excel Programming | |||
Edit userform | Excel Programming | |||
Edit a userform | Excel Programming | |||
View Row Data in UserForm / Edit | Excel Programming |