Custom Ribbon

[thes4s67]

Hi everyone,

I created a Ribbion using Custom UI Editor. You can check it out here. My question is how would I be able to make this ribbon available to all my Excel workbooks. Currently it only works on a particular workbook that has all the code. I assume I would have to make an Excel plugin or addon to make it work on all my excel workbooks. What is the easiest way for a person who has basic VBA knowledge??

 

[anvg]

Hi
Save your workbook with a custom ribbon to Excel AddIn (xlam) and add to your Excel autostarup folder or connect to Excel as AddIn.

Regards,

 

[My Aswer Is This]

Here is something I did.
1.Create yourself a UserForm and name it "Master"
2.Put in about five command buttons
3. Put this text in your Command Button: "Color My Cells"
4. Then put this script in your command button:

Private Sub CommandButton1_Click()
Me.Hide
Call Color_My_Cells
End Sub

Then create a module script like this:

Sub Show_Master()
Master.Show
End Sub

Put both your" Master" UserForm and your module script in your Personal file.
Now when you run the script "Show Master" it will cause your UserForm "Master" to pop up and when you click on the Command Button "Color My Cells" it will run your script "Color_My_Cells"

Then you could add several more Command Buttons to you Userform and be able to run any macro you want from this UserForm.

Just remember your UserForm and all your scripts must be in your personal Workbook. And then these scripts will all work from any WorkBook

 

[thes4s67]

Hi
Save your workbook with a custom ribbon to Excel AddIn (xlam) and add to your Excel autostarup folder or connect to Excel as AddIn.

Regards,

Thanks this worked for me.