Macros I want dont appear in the customise box to drag to a toolbar

J

Johnnyboy5

Hi

I have a macro that works using a key board short cut, but when I try
to assign it to a toolbar function when I select "macros" in the list
of commands the macro I want isn't listed there. only custom menu
item and custom button (with a smiley face)

help !


Johnny
 
G

Gord Dibben

While in Tools>Customize>Commands>Macros................

Drag Smiley Face up to a Toolbar.

Right-click on Smiley and "Assign Macro".

Choose from macro selection window.

Note you can also change Smiley to another Icon


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros not showing when trying to Customise toolbar 0
Word 2007 macros in add-ins do not show 0
How to remove customized button from toolbar? 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Excel 2007 - Can Macros be added to the Quick Access Toolbar 2
XLM Macros: Problems With Custom Toolbar Buttons 0
Unable to assign macros to a new button in the current worksheet 1
How to assign macro coding into customized button? 4

Top