Ribbon stopps working after Save

B

benspain_uk

In my workbook with a custom ribbon tab I have two macros that save a
workbook. One just saves the workbook, the other does a load of stuff
(imports from db, alter ranges etc.) then saves the workbook.

In both, I use the command:

ThisWorkbook.SaveAs Filename:=strFileSaveName,
FileFormat:=xlOpenXMLWorkbookMacroEnabled

In the long macro - the custom tab on the ribbon stops working after I
save the workbook, however the shorter one doesn't.

Even weirder, if I then close and reopen after saving the workbook
with the longer macro - the ribbon works with no problem!

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top