| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow text in locked cells on a worksheet from a userform
I have a userform that is set up when the user hits the submit button
it automatically loads the textboxes that the user filled out in the userform to a worksheet. The problem I'm having is that I want to lock the worksheet that the data is loading from the userfom, but if I lock the worksheet then the submit button will not work. The code crashes because I locked the worksheet. Is there any way let the users submit the data gathered on the userform but only give the users read access only on the worksheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing row deletion in worksheet with locked cells | Excel Discussion (Misc queries) | |||
| Edit Locked Cells with UserForm only | Excel Programming | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| What to do if the worksheet is locked on selecting rows or cells? | Excel Discussion (Misc queries) | |||
| Across a worksheet, which cells I have formatted as locked? | Excel Worksheet Functions | |||
Threaded Mode
