Occurs when any worksheet is double-clicked, before the default double-click
action.

Private Sub object_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target
As Range, ByVal Cancel As Boolean)

object Application or Workbook. For more information about using events
with the Application object, see Using Events with the Application Object.

Sh A Worksheet object that represents the sheet.

Target The cell nearest to the mouse pointer when the double-click
occurred.

Cancel False when the event occurs. If the event procedure sets this
argument to True, the default double-click action isn't performed when the
procedure is finished.

Remarks
This event doesn't occur on chart sheets.



so where it shows Object, if using Chip's page example, that Object would be
replace with App



In the class module it would be declared as:



Public WithEvents App As Application

Private Sub App_SheetBeforeDoubleClick(ByVal Sh As Object, _

ByVal Target As Range, ByVal Cancel As Boolean)

if lcase(sh.Name) = "mysheet" and lcase(sh.parent.name) =
"myworkbook.xls" then
sh.Range("A1").Value = "You double clicked"
end if

End Sub

then in the event, you can test if this is the sheet (sh.Name) and workbook
(sh.parent.name) that you want to react to.


for an example workbook, Chip offers one at the page I cited.

--
Regards,
Tom Ogilvy




"JGeniti" wrote in message
ups.com...
Tom,
I think this might be more of my lack of understanding of how to
incorporate Chips example into what I'm trying to do. I have been
researching this for a couple of hours and all of the examples of
application events that I have seen seem to reference application
events like opening, closing or creating new workbooks. How would I
break it down to the worksheet level? I hate to seem like I'm asking
you to force feed me this, but for some reason I have been unable to
get the examples that I have seen to work for me.

If you have any type of example of capturing the worksheet events it
would be very helpful.

Thank you,
James