Hello all!

I currently have an excel workbook (2010) in which I created a custom ribbon and assigned several different macros to teh buttons.

Long story short, I will be saving several variations of this workbook every so often when I get new data.

The problem is that if I change the name of the file (Save as or Rename), the custom ribbon buttons no longer work. When I assigned the macros to the ribbon buttons, the macros were absolutly assigned.

Is it possible to asign relative macros to custom ribbons?



From research I have done, it appears that custom ribbons cannot be created using VBA. Is this still true? The posts I was reading were from several years back. Has anyone found any alternatives to the above restriction?

Thanks,

Grazian2