Hi

Sorry the story may seem long winded, but I'm trying to describe it
logically so the problem can be easily understood.

I have added a new menu to the toolbar at the top of Excel, and assigned a
macro (called "USLE") to it that opens a userform. It was all working fine
until I made some changes to my VBE code, and I don't know what I've done
that causes the Excel to shut when I click on my menu...

Here is what happens:
When I click on my menu, the Security Warning window prompts and I click
"Enable Macros" as usual, the workbook then opens (but NOT the userform when
it should!), and an error message prompts saying "Microsoft Office Excel has
encountered a problem and needs to close", with the "Recover my work and
restart Microsoft Office Excel" option checked.

If I click on the recovered file in the Document Recovery panel in the left
of the new Excel opened automatically, save it and close the workbook (but
keep the Excel open), then click on my menu again, the userform then opens OK
and everything is fine!

However, if I start a new Excel application and click on my menu, the same
problem happens again...

Why is this?