I want to add a macro to a toolbar, which I have done before but now it does
not work so I must have forgotten something. I go to customise toolbars and
then select 'commands' and 'macros'. The problem is that my macros are not
shown, just 'Custom menu item' and 'Custom button'. How do I make my macros
visible?

Thanks for any help.
Dudley

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it does
not work so I must have forgotten something. I go to customise toolbars and
then select 'commands' and 'macros'. The problem is that my macros are not
shown, just 'Custom menu item' and 'Custom button'. How do I make my macros
visible?

Thanks for any help.
Dudley

That works fine. Thanks very much for your help.

Dudley

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it does
not work so I must have forgotten something. I go to customise toolbars and
then select 'commands' and 'macros'. The problem is that my macros are not
shown, just 'Custom menu item' and 'Custom button'. How do I make my macros
visible?

Thanks for any help.
Dudley

How do you get to the "custom button" option? I can't find that anywhere? I'm
trying to add a custom button to my toolbar and assign a macro to it, but I
can't even find where to add the button?

Thanks!
-Brittany

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it does
not work so I must have forgotten something. I go to customise toolbars and
then select 'commands' and 'macros'. The problem is that my macros are not
shown, just 'Custom menu item' and 'Custom button'. How do I make my macros
visible?

Thanks for any help.
Dudley

Right click any toolbar
Select Customize
On the Commands tab select Macros from Categories
You'll see the custom button icon (smiley face) in Commands
Click it and drag it to your toolbar

--
Biff
Microsoft Excel MVP


"britt_04" wrote in message
...
How do you get to the "custom button" option? I can't find that anywhere?
I'm
trying to add a custom button to my toolbar and assign a macro to it, but
I
can't even find where to add the button?

Thanks!
-Brittany

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it
does
not work so I must have forgotten something. I go to customise toolbars
and
then select 'commands' and 'macros'. The problem is that my macros are
not
shown, just 'Custom menu item' and 'Custom button'. How do I make my
macros
visible?

Thanks for any help.
Dudley

Hello

When I right-click to assign macro, nothing happens. What am I doing wrong?
Please help.
--
Thanks


"T. Valko" wrote:

Right click any toolbar
Select Customize
On the Commands tab select Macros from Categories
You'll see the custom button icon (smiley face) in Commands
Click it and drag it to your toolbar

--
Biff
Microsoft Excel MVP


"britt_04" wrote in message
...
How do you get to the "custom button" option? I can't find that anywhere?
I'm
trying to add a custom button to my toolbar and assign a macro to it, but
I
can't even find where to add the button?

Thanks!
-Brittany

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it
does
not work so I must have forgotten something. I go to customise toolbars
and
then select 'commands' and 'macros'. The problem is that my macros are
not
shown, just 'Custom menu item' and 'Custom button'. How do I make my
macros
visible?

Thanks for any help.
Dudley

How do I assign multiple macros to my custom toolbar?
--
Thanks for your help.


"user" wrote:

Hello

When I right-click to assign macro, nothing happens. What am I doing wrong?
Please help.
--
Thanks


"T. Valko" wrote:

Right click any toolbar
Select Customize
On the Commands tab select Macros from Categories
You'll see the custom button icon (smiley face) in Commands
Click it and drag it to your toolbar

--
Biff
Microsoft Excel MVP


"britt_04" wrote in message
...
How do you get to the "custom button" option? I can't find that anywhere?
I'm
trying to add a custom button to my toolbar and assign a macro to it, but
I
can't even find where to add the button?

Thanks!
-Brittany

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it
does
not work so I must have forgotten something. I go to customise toolbars
and
then select 'commands' and 'macros'. The problem is that my macros are
not
shown, just 'Custom menu item' and 'Custom button'. How do I make my
macros
visible?

Thanks for any help.
Dudley

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

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

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

user wrote:

Hello

When I right-click to assign macro, nothing happens. What am I doing wrong?
Please help.
--
Thanks

"T. Valko" wrote:

Right click any toolbar
Select Customize
On the Commands tab select Macros from Categories
You'll see the custom button icon (smiley face) in Commands
Click it and drag it to your toolbar

--
Biff
Microsoft Excel MVP


"britt_04" wrote in message
...
How do you get to the "custom button" option? I can't find that anywhere?
I'm
trying to add a custom button to my toolbar and assign a macro to it, but
I
can't even find where to add the button?

Thanks!
-Brittany

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it
does
not work so I must have forgotten something. I go to customise toolbars
and
then select 'commands' and 'macros'. The problem is that my macros are
not
shown, just 'Custom menu item' and 'Custom button'. How do I make my
macros
visible?

Thanks for any help.
Dudley




--

Dave Peterson