Have you tried to create an add-in with your macros (just save a worksheet containing your macros as excel add-in .xla in save as menu), then place it in excel add-ins folder, or startup folder. Then refer to this add-in macros to put buttons on the toolbar. this way, the toolbar macro buttons will not open macros from other worksheets, because this addin containing macros will allways start when excel starts.