Custom Ribbon for a single workbook

[tiredofit]

I have created a Custom Ribbon for my workbook called Fruits.xlsm.

If the user opens a new workbook within the same session of Excel, ie clicks Ctrl + N, that Custom Ribbon remains.

Is there a way for the Custom Ribbon to exist only for Fruits.xlsm and not for other workbooks with the same session of Excel?

I have tried googling but a lot of the responses point to links written by Ron De Bruin, which sadly, haven been removed.

Thanks

 

[Trevor G]

Look to save the workbook as an addin and then you should be able to use the addin on the one workbook you want to use it.

 

[tiredofit]

Look to save the workbook as an addin and then you should be able to use the addin on the one workbook you want to use it.

Thanks, will try that.