Macros Don't Show On Commands List and 'Normal.dot'

[SV]

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]

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

 

[Gord Dibben]

SV

See responses in-line below.

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

<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?

Tools>Customize>Toolbars>New to create a new blank toolbar.

Next step

Tools>Customize>Commands.

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

 

[Gord Dibben]

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

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

Gord Dibben MS Excel MVP