Minor problem:
I have a spreadsheet with a custom menu. The problem I have is:
1. User opens the file (Base) and the menu is created.
2. User does File-Save As (MyFile1). Custom menu still there.
3. User reopens the "Base" file. The custom menu is deleted and recreated.
4. User closes MyFile1. The custom menu is deleted, but "Base" is still open.
Is there a way to keep the custom menu as long at least one file that contains the createmenu macro is open? Right now, I have a command button on my spreadsheet that restores the menu (runs createmenu macro).
Thanks for the help.
I have a spreadsheet with a custom menu. The problem I have is:
1. User opens the file (Base) and the menu is created.
2. User does File-Save As (MyFile1). Custom menu still there.
3. User reopens the "Base" file. The custom menu is deleted and recreated.
4. User closes MyFile1. The custom menu is deleted, but "Base" is still open.
Is there a way to keep the custom menu as long at least one file that contains the createmenu macro is open? Right now, I have a command button on my spreadsheet that restores the menu (runs createmenu macro).
Thanks for the help.