We use an excel with a custom Ribbon and Macro's for calculation purposes. For each calculation a new File. These calculations are used by several users, who use these files both at work and at home. For this we decided the include the Ribbon in the calculation file and not in a seperate Add-Inn.

As the Ribbon and Macro's are being developed from time to time I would like the following to happen: On opening the Excel File check weather the back up bas files and customUI are available (only at work), if so delete the old customUI and Macro Modules and load new ones. For the Macro's I found ways to do this, not for the CustomUI. Is there a way to do this with a Macro at opening the Excel?