Hi Andrew,
I had the very same problem - and by "hiding" the formulas in the cells and
protecting the worksheet - when my users now copy & paste it only copies the
values.
Hope this helps.
Regards,
WendyUK
"AJPendragon" wrote:
I have a spreadsheet - users enter data in the sheet and need to copy to
other similar cells. However I want them to only Copy - Paste Special
(Values) so that the formulas and conditional formats are not copied with
them.
Can I either force Paste Special or disable normal paste; or is there a way
of "freezing" formulas and conditional formats to their original cells.
Thanks
Andrew
|