Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |