View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] soundneedle@hotmail.com is offline
external usenet poster
 
Posts: 5
Default Open Event not working

I have a workbook template that is opened "externally" via code---a
VB-like form opens the workbook and creates a new worksheet. I don't
have access to this code, but I do need to add code to the template
that is triggered either upon open or creating the new sheet. However,
neither of these events will trigger since the book is being opened via
external code.

Is there anyway to work around this? I cannot modify the VB-like form
or the module that is initially opening the book and creating the new
worksheet.

TIA...