How to create new workbook with custom ribbon in VBA

I created a workbook with multiple macros and a customized ribbon. One of the subs creates a new workbook. I would like to have the same custom ribbon in the new workbook. Is that achievable through VBA? Is there a way to export/import customUI files with VBA?

LOL

Sorry Michal your thinking is too literal.

Instead of creating a new workbook, why not save your existing workbook under a new name.

Then add the new sheets you want and delete those you don't want.

Your Customised ribbon should remain in the new workbook.

OK, this trick should do the job in my case, so thanks.
But taking it one step further - what if I wanted to have the new file with a different ribbon customization? Is it possible to import/export customUI files or modify them through VBA?
Or maybe it's possible to turn some buttons visible/invisible?

Yes, it is possible to make buttons visible/invisible (getVisible). You can also make dynamic menus.

One way is to make the ribbon into an add-in.

GetVisible is what I'll go with. Thanks!

Great, getVisible is really quite useful!

I have one more question regarding making the ribbon into an add-in. I read a bit about add-ins as I never used them before (conciously) and it seems like that might be an elegant and easy way to achieve what I need.
The macro I'm working on is going to be used in my company by multiple users, probably in different locations as well. The question is how would I distribute the workbook with references to an add-in. Do I need to deliver two separate files (original macro and add-in file) or is there a way to incorporate the add-in into the macro (like customUI file).
Sorry if this question sounds silly, as I said I'm new to the add-in concept.

It's not my forte, but I'll try to give you a bit of an idea how I see it.

It works like a workbook, with customUI and everything, but the worksheets are not shown.

You can for instance make one of your workbooks with the Ribbon into an Add-in by:

Please Login or Register  to view this content.

then resave it as an .xlam-file

The worksheets in the Add-in, not shown directly, can be used to store data used by your scripts, etc.

When working with an Add-in, it's important to write the code for the particular workbook you work with as "Activeworkbook" and when you may want to use data or preferences stored in the Add-in you use "Thisworkbook".