I have just created an auditing tool for Excel. It is a
spreadsheet which opens up and has its own menu. I now
want to covert it into an Excel Add-in. However I am not
clear what changes, if any, need to be made to my menu
creation code.
In the xls version, I have a Workbook_Open event that
creates the menu and a Workbook_Close Event that Deletes
the menu. If I now covert it to an xla file(Add-in), does
Excel treat it as an open file? Will it always display my
menu? That is, once clicked as an Add-in, will the menu
deletion code that I have in my Workbook_Close event
become redundant?
Is there anything I should know before converting this to
an xla file?
Thank-you
Bookmarks