| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent edit of cells
Dear experts,
I've a worksheet with a macro which when users fill-in column A, auto current dates and times appear in columns B & C respectively. I want after the dates and times filled into cells in columns B & C, they cannot be edited anymore. I tried to lock the cells by "Protection" but a run-time error dialog box appeared. Is there a way to solve this problem? Please advise. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent cells highlighting | Excel Discussion (Misc queries) | |||
| can i prevent duplications in cells | Excel Worksheet Functions | |||
| Allow Edit Prevent Delete | Excel Worksheet Functions | |||
| Lock Cells to Prevent Changes | Excel Discussion (Misc queries) | |||
| How do I prevent users to delete a worksheet, but allow to edit? | Excel Discussion (Misc queries) | |||
Threaded Mode
