![]() |
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