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

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

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