Quick Access Tool Bar [Closed]

Report
-
Hi Everyone,

I'm new to this forum. Thanks for the help and advise in advance.

I'm a beginner to VBA. I have created a custom Quick Access Tool bar to add a sheet after the last available sheet and the toolbar is default for all the workbooks. I have the Macro written in a separate workbook "Macros". The problem is when I open a new workbook and click the toolbar to insert a new sheet, it opens the Macros workbook as well. Wondering if there's a way to just insert the sheet without opening the Macros workbook everytime.

Thanks
Dubey

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!