| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Sheet Format when Data is Pasted
Is there any way to protect my worksheets format?
The trouble is that when people copy and paste into my worksheet they always paste the other sheets formats. I would like to be able to prevent this. They need to be able to copy the data, but not the format. Thanks, Dan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect Sheet Format when Data is Pasted
Could you train them to CopyPaste SpecialValuesOKEsc?
Gord Dibben MS Excel MVP On Thu, 20 Sep 2007 13:20:07 -0700, Draino wrote: Is there any way to protect my worksheets format? The trouble is that when people copy and paste into my worksheet they always paste the other sheets formats. I would like to be able to prevent this. They need to be able to copy the data, but not the format. Thanks, Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
| How do I protect a worksheet from being copied & pasted? | Excel Discussion (Misc queries) | |||
Linear Mode
