Digita
10-02-2008, 03:52 PM
Greetings,
Hope you can help.
I have a workbook in which users have marked certain cells with a particular color to ensure the contents are kept intact from any macro execution.
Obviously any code that changes the contents of a range would contain a line at front end to evaluate the interior colorindex number of each cell before updating same.
Changing cell fill color can also be done by format pasting. Would there be any way to restrict the selection of color to only 2 options: no fill color and a particular color only?
Thanks in advance.
Regards
Hope you can help.
I have a workbook in which users have marked certain cells with a particular color to ensure the contents are kept intact from any macro execution.
Obviously any code that changes the contents of a range would contain a line at front end to evaluate the interior colorindex number of each cell before updating same.
Changing cell fill color can also be done by format pasting. Would there be any way to restrict the selection of color to only 2 options: no fill color and a particular color only?
Thanks in advance.
Regards