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...
Bookmarks