I received a couple nifty little macros in this group the other day and have
set everything up to implement them.
My plan is to add buttons to a toolbar to run them.

I hopped over to "Help" and read the instructions which said to go to Tools
Customize Commands Tab and

<snip
Click the Commands tab.
In the Categories box, click a category for the command you want the button
to perform.
Drag the command or macro (macro: An action or a set of actions you can use
to automate tasks. Macros are recorded in the Visual Basic for Applications
programming language.) you want from the Commands box to the displayed
toolbar.
</snip

But my macros don't show up on the list of commands. They do show up in
Tools Macros Macros, and they work, too.

Is there something I need to do to have them show in my Commands list so I
can make buttons on the toolbar?
Maybe I'm missing a step?

Also, my plan is to provide these scripts to my co-workers via a workbook
saved on our shared server. I figured I'd create a workbook, add the macros
and buttons, and off we go. But I was planning on making the toolbars VERY
limited in this workbook as its purpose is simply to apply the macros (Very
limited use, but nice as heck to have).
If I change the toolbar in a workbook, does that change my default toolbars
for current/new workbooks?
Will opening a workbook with a different, customized toolbard change
anything in my defaults?

I'm figuring it won't... but would like a little more certainty.

So, do I need to so something to get my custom macros to show up on the
commands list so I can apply them to buttons?
Will changing my toolbar in a given workbook affect my defaults or current
workbooks?

TIA,
Shane

I played around a bit and found that, once I dragged the button onto the
toolbar, a right-click brings up a menu that includes "Assign Macro" :-)

Shane

"SV" wrote in message
...
I received a couple nifty little macros in this group the other day and
have set everything up to implement them.
My plan is to add buttons to a toolbar to run them.

I hopped over to "Help" and read the instructions which said to go to
Tools
Customize Commands Tab and

<snip
Click the Commands tab.
In the Categories box, click a category for the command you want the
button to perform.
Drag the command or macro (macro: An action or a set of actions you can
use to automate tasks. Macros are recorded in the Visual Basic for
Applications programming language.) you want from the Commands box to the
displayed toolbar.
</snip

But my macros don't show up on the list of commands. They do show up in
Tools Macros Macros, and they work, too.

Is there something I need to do to have them show in my Commands list so I
can make buttons on the toolbar?
Maybe I'm missing a step?

Also, my plan is to provide these scripts to my co-workers via a workbook
saved on our shared server. I figured I'd create a workbook, add the
macros and buttons, and off we go. But I was planning on making the
toolbars VERY limited in this workbook as its purpose is simply to apply
the macros (Very limited use, but nice as heck to have).
If I change the toolbar in a workbook, does that change my default
toolbars for current/new workbooks?
Will opening a workbook with a different, customized toolbard change
anything in my defaults?

I'm figuring it won't... but would like a little more certainty.

So, do I need to so something to get my custom macros to show up on the
commands list so I can apply them to buttons?
Will changing my toolbar in a given workbook affect my defaults or current
workbooks?

TIA,
Shane

SV

See responses in-line below.

On Wed, 13 Dec 2006 10:25:40 -0500, "SV"
wrote:

I received a couple nifty little macros in this group the other day and have
set everything up to implement them.
My plan is to add buttons to a toolbar to run them.

I hopped over to "Help" and read the instructions which said to go to Tools
Customize Commands Tab and

<snip
Click the Commands tab.
In the Categories box, click a category for the command you want the button
to perform.
Drag the command or macro (macro: An action or a set of actions you can use
to automate tasks. Macros are recorded in the Visual Basic for Applications
programming language.) you want from the Commands box to the displayed
toolbar.
</snip

But my macros don't show up on the list of commands. They do show up in
Tools Macros Macros, and they work, too.

Is there something I need to do to have them show in my Commands list so I
can make buttons on the toolbar?
Maybe I'm missing a step?

ToolsCustomizeToolbarsNew to create a new blank toolbar.

Next step

ToolsCustomizeCommands.

Scroll down to "Macros" and select.

Drag the smiley face to your new toolbar and drop it.

Right-click on smiley face and "Assign Macro"

Select from the list of macros that pops up.

You can change the smiley face while still in customize mode by right-click and
"Change Button Image"

You will follow these steps for each macro you want assigned to a button on your
new toolbar.


Also, my plan is to provide these scripts to my co-workers via a workbook
saved on our shared server. I figured I'd create a workbook, add the macros
and buttons, and off we go. But I was planning on making the toolbars VERY
limited in this workbook as its purpose is simply to apply the macros (Very
limited use, but nice as heck to have).
If I change the toolbar in a workbook, does that change my default toolbars
for current/new workbooks?

Yes, the new toolbar will show up with every workbook when done this way.

Will opening a workbook with a different, customized toolbard change
anything in my defaults?

Not to existing menus and toolbars, just will add new toolbar as above.


I'm figuring it won't... but would like a little more certainty.

So, do I need to so something to get my custom macros to show up on the
commands list so I can apply them to buttons?

See first response above.

Will changing my toolbar in a given workbook affect my defaults or current
workbooks?

In order to have a new toolbar available for ONLY ONE workbook, you must create
the toolbar on opening that workbook and deleting when closing that workbook.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP


TIA,
Shane

Shane

See my response to your other post on same subject, different subject line.

Best to stay in one thread so answers don't get duplicated.


Gord

On Wed, 13 Dec 2006 11:56:28 -0500, "SV"
wrote:

I played around a bit and found that, once I dragged the button onto the
toolbar, a right-click brings up a menu that includes "Assign Macro" :-)

Shane

"SV" wrote in message
...
I received a couple nifty little macros in this group the other day and
have set everything up to implement them.
My plan is to add buttons to a toolbar to run them.

I hopped over to "Help" and read the instructions which said to go to
Tools
Customize Commands Tab and

<snip
Click the Commands tab.
In the Categories box, click a category for the command you want the
button to perform.
Drag the command or macro (macro: An action or a set of actions you can
use to automate tasks. Macros are recorded in the Visual Basic for
Applications programming language.) you want from the Commands box to the
displayed toolbar.
</snip

But my macros don't show up on the list of commands. They do show up in
Tools Macros Macros, and they work, too.

Is there something I need to do to have them show in my Commands list so I
can make buttons on the toolbar?
Maybe I'm missing a step?

Also, my plan is to provide these scripts to my co-workers via a workbook
saved on our shared server. I figured I'd create a workbook, add the
macros and buttons, and off we go. But I was planning on making the
toolbars VERY limited in this workbook as its purpose is simply to apply
the macros (Very limited use, but nice as heck to have).
If I change the toolbar in a workbook, does that change my default
toolbars for current/new workbooks?
Will opening a workbook with a different, customized toolbard change
anything in my defaults?

I'm figuring it won't... but would like a little more certainty.

So, do I need to so something to get my custom macros to show up on the
commands list so I can apply them to buttons?
Will changing my toolbar in a given workbook affect my defaults or current
workbooks?

TIA,
Shane



Gord Dibben MS Excel MVP