to ron de bruin
Hi ron,to continue from my question and your answers of 3/8/05 all works
fine but is there any way i could make a template of the workbook because at
the moment every time i close it colors all blank cells what i need is to
make a template with the code but to save the template without coloring the
cells but when new sheet called from template then when save work as normal
coloring cells as your original coding. Does that make sense
--
BD3