I've set the spread sheet and have locked all the cells but those that I
want to have filled with data. There are time when I would like to be able
to C&P the data to other sheets but when I do I also copy the format. I
know I can use "paste special" but I want it so anyone can use the C&P
without having to use "paste special".

Marc