0

I have a macro attached to a button in a custom ribbon. I want to have variants of this file and I won't be the only one using this file. However, if I even just do a Save As and change the file name and I press the button it has to open the old excel file to run it. Is there a way to avoid this?

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
fungrymonster
  • 25
  • 1
  • 6
  • 1
    Try convert it into a `.xltm` - macro enabled excel template as the master one. New files based on this template also needs to be macro enabled workbook `.xlsm` – PatricK Feb 13 '17 at 23:54
  • Maybe this [link](http://stackoverflow.com/questions/8850836/how-to-add-a-custom-ribbon-tab-using-vba) will helpful. – Andy Feb 14 '17 at 05:19

1 Answers1

0

enter image description here

This is what I did and it worked. Thank for the answers

fungrymonster
  • 25
  • 1
  • 6