Hi,
Right-click your sheet tab and select View Code.
Copy and Paste the following into the worksheet window:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)If Not
Intersect(Target, Range("A1")) Is Nothing Then Call macroEnd Sub
Change the range ref to the cell you want to use.
Change the word 'macro' for the name of the macro you want to run.
Hope this helps.
Regards - Dave.
> Date: Thu, 11 Sep 2008 08:08:49 -0700> Subject: $$Excel-Macros$$ Make a cell
> a control that launches macro when clicked> From: [EMAIL PROTECTED]> To:
> [email protected]> > > 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,> > >
> _________________________________________________________________
Net yourself a bargain. Find great deals on eBay.
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Frover%2Eebay%2Ecom%2Frover%2F1%2F705%2D10129%2D5668%2D323%2F4%3Fid%3D10&_t=763807330&_r=hotmailTAGLINES&_m=EXT
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
