LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SV SV is offline
external usenet poster
 
Posts: 15
Default Macros Don't Show On Commands List and 'Normal.dot'

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"