Ribbon Tab Customisation

[Pacman52]

Hi all,

So I have created a new ribbon tab called 'Finances' and wanted to know if its possible to open a Workbook from a section on the tab that will be located on a shared folder?

I know this could be done with a macro using Workbook.open method but I'm lost as to where the macro would be written to be able to assign it to the ribbon?

Anyone have any solutions or advice please?

many thanks Paul

 

[skillilea]

You can customize your ribbon by adding a new tab then a group.
Then you choose your macro from macros under "Macros" and drag it in. See below

Here is a video explaining it.

If you want more control this tool may help you

Office RibbonX Editor

 

[Pacman52]

thank you so much I'll have a look at that