Also watch for linewrap when you paste it in. The sub line should all be on the same line. This part should all be on the same line across(don't attempt the continuation line) Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
-----Original Message----- From: Windows Home/SOHO [mailto:[EMAIL PROTECTED] Behalf Of Slattery, Tim - BLS Sent: Monday, April 17, 2006 3:18 PM To: [email protected] Subject: Re: onClick for cell in Excel > Tim- > I don't know the beginning of this thread, but that > code is supposed to go into the Sheet Module, by right > clicking on the sheet tab and choosing view code. It does not > go into a standard module(module 1 as you called it). Do not > change the name of the sub. OK, I put it into a Sheet Module, named it back to W0rksheet_BeforeLeftClick. Nothing happens. > And yes, you can call a macro from a > shape(maybe like something from the drawing toolbar) by right > clicking on the shape and then assigning your chosen macro to it. Maybe I'll try that. Can't do any worse. -- Tim Slattery [EMAIL PROTECTED] -- ---------------------------------------- To Change your email Address for this list, send the following message: CHANGE WIN-HOME your_old_address your_new_address to: [EMAIL PROTECTED] Note carefully that both old and new addresses are required. -- ---------------------------------------- To Change your email Address for this list, send the following message: CHANGE WIN-HOME your_old_address your_new_address to: [EMAIL PROTECTED] Note carefully that both old and new addresses are required.
