Att: Hitesh Dilipbhai Dhare Open VBE Go to View -> Project Explorer Click on the Sheet name to view its private module See attached for example
_________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." --- On Fri, 12/9/08, Hitesh Dilipbhai Dhare <[EMAIL PROTECTED]> wrote: From: Hitesh Dilipbhai Dhare <[EMAIL PROTECTED]> Subject: $$Excel-Macros$$ Make a cell a control that launches macro whenclicked To: excel-macros@googlegroups.com Date: Friday, 12 September, 2008, 11:02 AM HI, How to include macro in private module? Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Alokeshwar Tiwary Sent: Friday, September 12, 2008 4:17 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Make a cell a control that launches macro whenclicked 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 PMIs there a way to set a cell so when the user clicks on it, itlaunches a specified macro? If so can you show me how it's done? Thank you, Unlimited freedom, unlimited storage. Get it now</a **************************************************************************************************** Idea has dropped its roaming tariff for you to be in touch with your loved ones when away from home. Now outgoing and incoming calls at Re. 1/min and STD at Rs. 1.5/min while roaming. Happy Roaming! **************************************************************************************************** ************************************************************************ ideacellular.com E-Mail Domain is now idea.adityabirla.com E-Mail Domain ************************************************************************ An idea can change your life. ************** LEGAL DISCLAIMER ************ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at [EMAIL PROTECTED] and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail. Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
<<inline: untitled.GIF>>
