Procedure kills copy and paste

B

Bura Tino

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Really Need Help: side effect clears clipboard!!! 3
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Change event to add button 2
Prevent copy and paste in one column 3
Need a accumulator driven from second cell 4
Disable Cut/Copy/Paste in Excel 2010 0
Run procedure in stored in module on worksheet change event 5
From Excel to user form 0

Top