Put this code behind the sheet that you are using
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Target.Address = "$A$1" Then
RightCellClicked
Else
WrongCellClicked
End If
End Sub
Insert a module in the workbook and put this code in:
Sub RightCellClicked()
MsgBox "You clicked target cell"
End Sub
Sub WrongCellClicked()
MsgBox "You didn't click the one we're looking for"
End Sub
When you double click A1 it will call the RightCellCLicked - any other
cell will call WrongCellClicked - soudns like you don't need that one
On Sep 11, 4:08 pm, Tony Bender <[EMAIL PROTECTED]> wrote:
> Is there a way to set a cell so when the user clicks on it, it
> launches a specified macro?
>
> If so can you show me how it's done?
>
> Thank you,
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to [email protected]
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
