| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I lock only the cells containing formulas?
I desperately need to be able to lock cells containing formulas in the
worksheets to which the data is being captured via my custom UserForm (that's housed on Sheet 1). I have to present my spreadsheet application to several directors tomorrow and I really need to have this functionality in place! I have several staff members that sometimes click into a cell after they've entered their data and ACCIDENTLY erase the formula. I've tried password protecting the sheets but them I get an error when entering the data via the UserForm (which is coded to send data to lastrow UNDER all my cells that contain the formulas. HELP PLEASE Thanks in advance for any guidance, -- Jennifer Lee IS Coordinator/App Support |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock in formulas | Excel Worksheet Functions | |||
| Lock formulas only not data | Excel Worksheet Functions | |||
| Lock and password protect only cells with formulas on all sheets in a workbook | Excel Programming | |||
| Can u lock individual cells (those containing formulas) in an Exc. | Excel Discussion (Misc queries) | |||
| Automatically lock cells and hide formulas | Excel Programming | |||
Threaded Mode
