Customized ribbon button Tab linking 3 folders|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

I have been looking at creating a new Ribbon tab and looking at grouping them with command to look through 3 folders and then selecting excel files.

Ive been looking at Custom UI Editor and although im new to this, I can create custom 2 macro buttons and work well, but what im looking at is if I could create new TAB in the ribbon - Inventory Database. The Group - Inventory Listings. The Button - Inventory Listing, Receipt Listing, Dispatch Listing. Then click on the button command listing various inventory listings within that button from the disignated folders.

I have 3 folders

Under Inventory Database

> Inventory Listing

NSW Spare Inventory Listing.xlsx

> Receipting Listing

NSW Spare Receipt Listing.xlsx

> Dispatch Listing

NSW Spare Dispatch Listing.xlsx

If someone can lead to some helpful hints or links to do this or even some education link this would be great

Thanks

steve