ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ribbon stopps working after Save (https://www.excelbanter.com/excel-programming/405674-ribbon-stopps-working-after-save.html)

[email protected]

Ribbon stopps working after Save
 
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?


All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com