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?