Hi, AMK. I've got a screenshot under Step 1 at:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"AMK" wrote in message
...
Hi
How does one set up a "Personal Macro Workbook"? I cannot find the store
dropdown menu.
Thanks.--
Al


"Norman Jones" wrote:


Hi Eugene,

Macros saved in your Personal workbook will be available to all
worksheets.

should be:

Macros saved in your Personal workbook will be available to all
workbooks

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Eugene,

Macros saved in your Personal workbook will be available to all
worksheets. If you do not already have a Personal workbook, record a
dummy
macro and select 'Peronal Macro Workbook' in the store dropdown. This
will
create the workbook and you can delete the dummy macro.

Alternatively, you can store the macros in a workbook, saving the
workbook
as a Microsoft Excel Addin in 'Save as Type' box. Then:
Tools | Addins | Browse to your saved Addin.
Thereafter, these macros will be available to all workbooks.


---
Regards,
Norman


"leaftye - ExcelForums.com"
wrote in message ...
Does the lack of responses mean it's not possible to do what I want
to
do, or that I need to go back and read chapter 1 of my excel
programming book?

Eugene