Macro button on all workbooks

[nygwnj]

I have a small piece of code saved in a workbook. I'd like to be able to add a button on the top of any workbook that can call this code. In the customize toolbar screen, I added a button for this macro to a sample workbook, but when I clicked it it said the macro wasn't accessible.

I can run it if the original workbook is open, and I click macros->view macros->find the right one->click run. One-click shopping would be better.

Gary

[Richard Buttrey]

Hi,

You don't say what version of Excel you have, nor indeed where you are located. Both of these pieces of information are useful to us when responding. When you have a moment perhaps you'd update them.

First add the macro to your 'Personal.xlsb' workbook. Then assuming you are using XL 2007 or 2010 then just go to the Customise Quick Acces toolbar, More Commands, choose macros, find the relevant macro and drag it across to the QA toolbar pane. It's then ready for you in the Excel App.

Regards

[royUK]

You probably need to create an addin. If you have a version earlier than 2007 then you can create a menu or commandbar, see examples at the bottom of this page. later versions you can add to the Ribbon