| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking all cells of a given color in a given range
Hi.
I'm trying to write a macro to look at all cells in a named range ("input_range") and 1) lock them if interior.colorindex = xlnone or 2) unlock them if interior.colorindex = 36. This routine should be called when a given cell's picklist value is changed. The cell with the picklist is actually two merged cells, and I've created a named range called "input_begin" for the picklist. Can somebody please recommend an approach? Thanks! -Michael *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the color of a range of cells | New Users to Excel | |||
| change the color of a range of cells | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| Color Range of Cells | Excel Programming | |||
![Michael Siegel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
