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