Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste special function in macros fail if we disable application cellDrap Drop
Hi,
I have an excel which has a inhouse format. When a user tires to paste data onto to the excel he should only be pasting values and not disturb the format / formulas in the excel.I have implemented this by using paste special when the user tries to paste.This can be done by capturing the paste keys and calling paste special instead. In addition to this I also need to diable the Cell Drag drop functionality so that no one should be able to drag the cells down and disturb the formulas.So I used the Application.CellDragDrop = false. This does throws error when paste special is called saying the paste special function of the range failed.If I comment the Application.CellDragDrop = false line it works fine.I have given the code below. Any help appreciated. Private Sub Workbook_Activate() Application.CellDragAndDrop = false Application.OnKey "^v", "Sheet1.Pastewithoutformatting" 'Added new function End Sub Private Sub Workbook_Deactivate() Application.CellDragAndDrop = true End Sub Sub PasteWithoutFormatting() Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlPasteSpecialOperationNone, SkipBlanks:=False, Transpose:=False Exit Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste special function in macros fail if we disable application cell Drap Drop
I don't think there is any way that the D&D setting affects Paste Special.
So I'd check for something else being the problem - not being in Copy mode, selection (paste selection) not being compatible with the range being copied, sheet protection,... Odd that your "false" and "true" below are not capitalized. -- Jim wrote in message ... | Hi, | I have an excel which has a inhouse format. When a user tires to | paste data onto to the excel he should only be pasting values and not | disturb the format / formulas in the excel.I have implemented this by | using paste special when the user tries to paste.This can be done by | capturing the paste keys and calling paste special instead. | In addition to this I also need to diable the Cell Drag drop | functionality so that no one should be able to drag the cells down and | disturb the formulas.So I used the Application.CellDragDrop = false. | This does throws error when paste special is called saying the paste | special function of the range failed.If I comment the | Application.CellDragDrop = false line it works fine.I have given the | code below. Any help appreciated. | Private Sub Workbook_Activate() | Application.CellDragAndDrop = false | Application.OnKey "^v", "Sheet1.Pastewithoutformatting" 'Added new | function | End Sub | Private Sub Workbook_Deactivate() | Application.CellDragAndDrop = true | End Sub | | Sub PasteWithoutFormatting() | Selection.PasteSpecial Paste:=xlPasteValues, | Operation:=xlPasteSpecialOperationNone, SkipBlanks:=False, | Transpose:=False | Exit Sub | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste special function in macros fail if we disable applicationcell Drap Drop
On Jan 22, 9:42*am, "Jim Rech" wrote:
I don't think there is any way that the D&D setting affects Paste Special. So I'd check for something else being the problem - not being in Copy mode, selection (paste selection) not being compatible with the range being copied, sheet protection,... Odd that your "false" and "true" below are not capitalized. -- wrote in message ... | Hi, | * I have an excel which has a inhouse format. When a user tires to | paste data onto to the excel he should only be pasting values and not | disturb the format / formulas in the excel.I have implemented this by | using paste special when the user tries to paste.This can be done by | capturing the paste keys and calling paste special instead. | In addition to this I also need to diable the Cell Drag drop | functionality so that no one should be able to drag the cells down and | disturb the formulas.So I used the Application.CellDragDrop = false. | This does throws error when paste special is called saying the paste | special function of the range failed.If I comment the | Application.CellDragDrop = false line it works fine.I have given the | code below. Any help appreciated. | Private Sub Workbook_Activate() | Application.CellDragAndDrop = false | Application.OnKey "^v", "Sheet1.Pastewithoutformatting" 'Added new | function | End Sub | Private Sub Workbook_Deactivate() | Application.CellDragAndDrop = true | End Sub | | Sub PasteWithoutFormatting() | * *Selection.PasteSpecial Paste:=xlPasteValues, | Operation:=xlPasteSpecialOperationNone, *SkipBlanks:=False, | Transpose:=False | * *Exit Sub | Ya I was of the same opinion that the D &D should not have any impact over pastespecial.but the funny thing is the paste special works absolutely fine if I remove / comment the D & D code. i.,e I comment Application.CellDragAndDrop = True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To give paste special (value) in macros | Excel Discussion (Misc queries) | |||
Cause workbook to fail to open if user opts to disable macros | Excel Programming | |||
Disable paste special attributes | Excel Programming | |||
Disable Paste Special | Excel Programming | |||
Disable the Edit menu command 'Paste Special' | Excel Programming |