I have a workbook which adds a menu to the excel menu bar when the
workbook is opened and removes it when it is closed.
The users now say they want to open many instances of the workbook as
different files to copy data between them.
My problem then is how to ensure only one menu is created and used and
how to ensure it is deleted when the last workbook is closed.
I can check if the menu exists on opening and only create if it does not
but how can I check that closing this workbook closes the last instance
of the workbook type that requires the menu. Other workbooks may still
be open.
I had thought I could add some identifying data to the workbook that
requires the menu and when closing check if more than one exists but I
could not work out how to do this.
Any help would be gratefully received.
--
Alan Beal
Printrak International Ltd. UK (0) 1202 862023
A stupid question is better than a stupid mistake.