Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to have a pop-up msg come up when someone tries to paste into a cell.
Is there a way to do this? I know how to create the pop-up, I just need to know how to create the code to run when an attempt to paste is executed. I created the following but the user has to double-click the cell and this is not practical: Private Sub Worksheet_BeforeDoubleClick( _ ByVal Target As Excel.Range, Cancel As Boolean) With Target If Application.CutCopyMode = False Then Cancel = True Else Application.Run "PasteWarning" End If End With End Sub Thanks in advance, Carl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simplify Command Button Procedure | Excel Discussion (Misc queries) | |||
Enable Command Button Procedure | Excel Discussion (Misc queries) | |||
UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED | Excel Programming | |||
How to elegantly end a main procedure from a userform command button? | Excel Programming | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |