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.

 

[DS-NTE]

And then you may turn it into an Addin.


knut

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.

 

[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)