Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically locking cells following data entry
I have a workbook that has 25 different worksheets.
The cells are all formatted as locked with the exception of those that are allowed for data entry. At a point when all data is added I want to be able to click on a button that will progress through all worksheets and lock all cells. Can anyone please provide me with the code or a macro that I can assign to a button to do this please. Thank you in advance. Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking from data entry but allowing oulining to function? | Excel Discussion (Misc queries) | |||
Locking cells automatically after enter | Excel Discussion (Misc queries) | |||
auto locking cells after new entry/edit | Setting up and Configuration of Excel | |||
Locking a cell after data entry (Excel 2003) | Excel Discussion (Misc queries) | |||
Automatically copy previous cells in data entry in Excel | Excel Discussion (Misc queries) |