Identifing Locked Cells
Paul -
The Macro Worked like a charm.
Steve
"Steve Klenner" wrote in message
...
I have a fairly complex spreadsheet that requires salespeople to fill in
info. Many cells are locked from being changed. Is there a way to create
a macro that looks a current sheet and will change the cell color if cell
is locked (or unlocked)? Right now I review by going from cell, to, cell,
to cell.....
Any suggestions is MUCH appreciated....
Steve
|