| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you get a macro not to go to or change a locked cell?
I have the cells locked, the sheet protected and have only "Select unlocked
cells" and "Format cells" checked. If I turn "Format cells" off, the macro doesn't work. Below is the macro: Selection.Interior.ColorIndex = 4 Selection.Font.ColorIndex = 1 ActiveCell.Offset(1, 0).Range("A1").Select It changes the fill to green, the text to black, and move down one row. Please help......... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you run a macro while your computer is locked? | Excel Discussion (Misc queries) | |||
| macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
| change locked cell if | Excel Discussion (Misc queries) | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Locked Macro Project | Excel Discussion (Misc queries) | |||
Threaded Mode
