I installed an Excel 2007 add-in which makes a new Tab in Ribbon and a custom popup menu in Quick Access Toolbar. With Excel opened I can open/install or close/uninstall the add-in without problem. When I open VBE, even if I do not make any modification, Excel (application) close/exit without problems.
When I do not open VBE and try to Close/Exit Excel an Error Window appears: "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience". There is a checkBox ('Recover my work and restart Microsoft Office Excel') which can restart Excel without any loss but it's annoying...
In order to solve that I open VBE in the Workbook BeforeClose event (using: SendKeys "%{F11}", True) and nothing wrong happen any more. But this is not an elegant solution...
Can anybody understand what is happening?
I do not attach the add-in because all the interface is in Romanian and its translation will take time. I would like to know if somebody else has faced this problem and how can it be solved elegantly...
Thanks in advance,
Fane Duru'
When I do not open VBE and try to Close/Exit Excel an Error Window appears: "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience". There is a checkBox ('Recover my work and restart Microsoft Office Excel') which can restart Excel without any loss but it's annoying...
In order to solve that I open VBE in the Workbook BeforeClose event (using: SendKeys "%{F11}", True) and nothing wrong happen any more. But this is not an elegant solution...
Can anybody understand what is happening?
I do not attach the add-in because all the interface is in Romanian and its translation will take time. I would like to know if somebody else has faced this problem and how can it be solved elegantly...
Thanks in advance,
Fane Duru'