Hi,

Im copying and pasting from one spread sheet to another.
The source spreadsheet has formula behind the cells, but I want to copy only
the values not the formula, easily achieved using "paste special".
Unfortunately some people are still using "paste" rather than "paste
special" and mucking up the new spreadsheet with unwanted formulas.
Is there any way of creating settings on cells in the new spreadsheet so
that it will not allow users paste formulas in them and only paste values?
Or even setting the default "paste" option for that spreadsheet to "values
only" so when they use paste it wont copy the formulas?

Thanks very much for any help you can give
cheers