Place this code in private module of the worksheet:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If ActiveCell.Address = "$C$3" Then
Cancel = True
Call MyMacro
End If
End Sub
As soon as user double clicks the Cell C3, it cancels the click action and
calls MyMacro.
_________________________________________________________________________________________________
--- On Thu, 11/9/08, Tony Bender <[EMAIL PROTECTED]> wrote:
From: Tony Bender <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Make a cell a control that launches macro when clicked
To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com>
Date: Thursday, 11 September, 2008, 8:38 PM
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,
Share files, take polls, and make new friends - all under one roof. Go to
http://in.promos.yahoo.com/groups/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
