Excel 2010.
When I close Excel, obviously, personal.xlsb closes too. But I have an Add-In Menu tree on the Add-Ins tab that does not close. The Sub
does not get activated. So the next time I start Excel I now have 2 copies of this menu on my Add-Ins ribbon. Suggestions.
Also a co-worker uses a few Macros I put in her Personal.xlsb file but she oftentimes open multiple copies of Excel so she gets a nag that says the file personal.xlsb is open for editing by herself. And she can open read-only or notify. Is there a way to avoid this message? Thanks.
When I close Excel, obviously, personal.xlsb closes too. But I have an Add-In Menu tree on the Add-Ins tab that does not close. The Sub
Code:
Sub Workbook_BeforeCloseAlso a co-worker uses a few Macros I put in her Personal.xlsb file but she oftentimes open multiple copies of Excel so she gets a nag that says the file personal.xlsb is open for editing by herself. And she can open read-only or notify. Is there a way to avoid this message? Thanks.
