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?
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?