Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict Copy to Values only?
Hi guys,
Could anyone be able to help me. I have two workbooks where the user must copy range of cells from one to the other, but only the values. Is there an automated way of restricting the copy function to only copy values? That is, within the first workbook, whenever the user copies some cells (via Ctrl+C or the toolbar) excel only copies the values. Therefore, in the second workbook the user only has to paste. Regards Nick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict Copy to Values only?
This sounds like it isn't a programming question, so:
There is no setting that will make Ctrl+C copy only values. or Ctrl+V paste only values. You can lock all cells, mark all cells hidden and protect the sheet for the source sheet and the user won't be able to copy formulas if that is your intent. -- Regards, Tom Ogilvy "nickm687" wrote: Hi guys, Could anyone be able to help me. I have two workbooks where the user must copy range of cells from one to the other, but only the values. Is there an automated way of restricting the copy function to only copy values? That is, within the first workbook, whenever the user copies some cells (via Ctrl+C or the toolbar) excel only copies the values. Therefore, in the second workbook the user only has to paste. Regards Nick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict Copy to Values only?
Maybe i should rephrase.
I am hoping to lock a worksheet so that only paste values is allowed. therefore whenever a user goes to paste it is only the the values, nothing else. the worksheet i am using contains much formatting but requires copying from another workbook, which in turn messes up everything. Regards Nick |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict Copy to Values only?
Why not create macros to copy the values for the users? you can control what
they copy and where it goes. "nickm687" wrote in message oups.com... Maybe i should rephrase. I am hoping to lock a worksheet so that only paste values is allowed. therefore whenever a user goes to paste it is only the the values, nothing else. the worksheet i am using contains much formatting but requires copying from another workbook, which in turn messes up everything. Regards Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RESTRICT TO PASTE VALUES ONLY | Excel Discussion (Misc queries) | |||
Restrict Data Values Allowed | Excel Worksheet Functions | |||
Restrict users from changing to certain values in a cell | Excel Discussion (Misc queries) | |||
Restrict copy paste ability | Excel Programming | |||
Restrict user entry to numeric values only | Excel Programming |