Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell manipulation
Looking to have certain cells ( where lock=false ) to have yellow background.
Else, standard white background. This should allow me to run macro whenever I want, in the event that cell locking or unlocking was changed. Assuming this would be a macro, for ease of use, I would prefer to be able to operate this from a button on my custom personal macro toolbar. John F. Scholten |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell manipulation
Are you using format|conditional formatting for anything on that worksheet?
If no, select A1 hit ctrl-a (twice in xl2003) format|conditional formatting formula is: =CELL("protect",A1)=0 format nicely (Pattern tab) John F wrote: Looking to have certain cells ( where lock=false ) to have yellow background. Else, standard white background. This should allow me to run macro whenever I want, in the event that cell locking or unlocking was changed. Assuming this would be a macro, for ease of use, I would prefer to be able to operate this from a button on my custom personal macro toolbar. John F. Scholten -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell manipulation
Dave:
Not quite what I had in mind. Thanks for your response. Sorry for posting this on programming group. I have "moved" it to new user - more appropriate, I think. John F. "Dave Peterson" wrote: Are you using format|conditional formatting for anything on that worksheet? If no, select A1 hit ctrl-a (twice in xl2003) format|conditional formatting formula is: =CELL("protect",A1)=0 format nicely (Pattern tab) John F wrote: Looking to have certain cells ( where lock=false ) to have yellow background. Else, standard white background. This should allow me to run macro whenever I want, in the event that cell locking or unlocking was changed. Assuming this would be a macro, for ease of use, I would prefer to be able to operate this from a button on my custom personal macro toolbar. John F. Scholten -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell manipulation with imaging | Excel Worksheet Functions | |||
Need Help with Cell Manipulation | Excel Discussion (Misc queries) | |||
Help w/ Cell Manipulation | Excel Worksheet Functions | |||
Cell Manipulation | Excel Programming | |||
Cell Manipulation | Excel Programming |