| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell lock
dearr
i have a sheet that is being updated from a form. i want the button on the form to lock the cells in which data has been entered and the empty cells remain unlock. any help will be appreciated thanks naweed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell lock
ActiveSheet.Unprotect
set rng = ActiveSheet.Cells.SpecialCells(xlConstants) rng.Locked = True ActiveSheet.Protect -- Regards, Tom Ogilvy " wrote: dearr i have a sheet that is being updated from a form. i want the button on the form to lock the cells in which data has been entered and the empty cells remain unlock. any help will be appreciated thanks naweed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell lock
On Jul 14, 9:42 pm, Tom Ogilvy
wrote: ActiveSheet.Unprotect set rng = ActiveSheet.Cells.SpecialCells(xlConstants) rng.Locked = True ActiveSheet.Protect -- Regards, Tom Ogilvy " wrote: dearr i have a sheet that is being updated from a form. i want the button on the form to lock the cells in which data has been entered and the empty cells remain unlock. any help will be appreciated thanks naweed- Hide quoted text - - Show quoted text - it worked perfectly. Thanks alot best regards, naweed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
| how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
| I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
| I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
Hybrid Mode
