Quick Access Tool Bar

Closed
Dubey - Jan 22, 2017 at 06:50 AM
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