software

I have Office XP and in Word I have macros on the toolbar. I go to customise
toolbar and select commands and then macros, I then see the macros listed and
I can drag them to the toolbar. But when I do this in Excel the macros are
not listed, just 'Custom menu item' and 'Custom button'. How do I get the
macros?

Thanks
Dudley

drag the icon to the toolbar.
rightclick on the icon (with that tools|customize dialog visible)
and choose assign macro.

When I want to create a toolbar, I do it via code:

I really like the way John Walkenbach does it in his menumaker workbook:
j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

It makes life much easier when the files are renamed/relocated/shared with
others.

Dudley wrote:
gt;
gt; I have Office XP and in Word I have macros on the toolbar. I go to customise
gt; toolbar and select commands and then macros, I then see the macros listed and
gt; I can drag them to the toolbar. But when I do this in Excel the macros are
gt; not listed, just 'Custom menu item' and 'Custom button'. How do I get the
gt; macros?
gt;
gt; Thanks
gt; Dudley

--

Dave Peterson

Thanks. That solves the problem. I don't know why they have to make it so
much more complicated than in Word.
Dudley

quot;Dave Petersonquot; wrote:

gt; drag the icon to the toolbar.
gt; rightclick on the icon (with that tools|customize dialog visible)
gt; and choose assign macro.
gt;
gt; When I want to create a toolbar, I do it via code:
gt;
gt; I really like the way John Walkenbach does it in his menumaker workbook:
gt; j-walk.com/ss/excel/tips/tip53.htm
gt;
gt; Here's how I do it when I want a toolbar:
gt; www.contextures.com/xlToolbar02.html
gt; (from Debra Dalgleish's site)
gt;
gt; It makes life much easier when the files are renamed/relocated/shared with
gt; others.
gt;
gt; Dudley wrote:
gt; gt;
gt; gt; I have Office XP and in Word I have macros on the toolbar. I go to customise
gt; gt; toolbar and select commands and then macros, I then see the macros listed and
gt; gt; I can drag them to the toolbar. But when I do this in Excel the macros are
gt; gt; not listed, just 'Custom menu item' and 'Custom button'. How do I get the
gt; gt; macros?
gt; gt;
gt; gt; Thanks
gt; gt; Dudley
gt;
gt; --
gt;
gt; Dave Peterson
gt;