no Hong Quach, I'm not aware of how to use separately, I did try however the
example showen on the help on the VB console that comes with excel "view
code", but I'm not sure how to make it change colors for specified sheet only
with selected range.
I'm also using links to this range in multiple sheets, that is, its visible
in multiple sheets but can only be changed from one sheet. is it possible to
make the macro change the format for the links aswell?