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

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

And then you may turn it into an Addin.


knut
"Dave Peterson" skrev i melding
...
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

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" skrev i melding
...
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