View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Calls from sheet module to ThisWorkbook module

I am using Office 2003 on Windows XP.

I have a "BeforeDoubleClick" event procedure in a Sheet module that needs to
call a "Workbook_Open" event procedure in the "ThisWorkBook" module. I tried
the following, but of course this produces an error:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Call Workbook_Open
End Sub

Can someone please correct my code above or otherwise describe how I can
accomplish this?

Thanks in advance.