Creating New Macro Workbooks

[bodhisatvaofboogie]

How do I go about creating a new workbook for macros??? There is the personal
workbook that is on the macro window when I record new ones, can I create a
new one that will show up for me to store macros in??? Thanks!!!

[Dave Peterson]

Just start a new workbook and put all your new macros in that workbook's
project.

Remember to save the workbook every so often.

If you want the macros to be available whenever you start excel, you can store
it in your XLStart folder.

bodhisatvaofboogie wrote:
>
> How do I go about creating a new workbook for macros??? There is the personal
> workbook that is on the macro window when I record new ones, can I create a
> new one that will show up for me to store macros in??? Thanks!!!

--

Dave Peterson

[DS-NTE]

And then you may turn it into an Addin.


knut
"Dave Peterson" <[email protected]> skrev i melding
news:[email protected]...
> Just start a new workbook and put all your new macros in that workbook's
> project.
>
> Remember to save the workbook every so often.
>
> If you want the macros to be available whenever you start excel, you can
> store
> it in your XLStart folder.
>
> bodhisatvaofboogie wrote:
>>
>> How do I go about creating a new workbook for macros??? There is the
>> personal
>> workbook that is on the macro window when I record new ones, can I create
>> a
>> new one that will show up for me to store macros in??? Thanks!!!
>
> --
>
> Dave Peterson

[Dave Peterson]

If you make it an addin, then you'll need to provide some way for the users to
run those macros (subroutines).

I like to add a new toolbar or add more options to the worksheet menu bar.

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)

DS-NTE wrote:
>
> And then you may turn it into an Addin.
>
> knut
> "Dave Peterson" <[email protected]> skrev i melding
> news:[email protected]...
> > Just start a new workbook and put all your new macros in that workbook's
> > project.
> >
> > Remember to save the workbook every so often.
> >
> > If you want the macros to be available whenever you start excel, you can
> > store
> > it in your XLStart folder.
> >
> > bodhisatvaofboogie wrote:
> >>
> >> How do I go about creating a new workbook for macros??? There is the
> >> personal
> >> workbook that is on the macro window when I record new ones, can I create
> >> a
> >> new one that will show up for me to store macros in??? Thanks!!!
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson