Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure kills copy and paste
Hi,
I have a procedure (shown below) which makes a Controls Toolbar button vizible if "A1" is selected. An unfortunate side effect is that having this procedure kills the ability to copy and paste -- if something had been selected and copied, it disappears once any other cell is clicked. Can anyone suggest a work around? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then AddFundButton.Visible = True Else AddFundButton.Visible = False End If End Sub Many thanks in advance, Bura |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
SP3 for Excel kills Add-ins | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Worksheet_Change Event - Macro kills copy and paste | Excel Programming |