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.