Posted to microsoft.public.excel.programming
|
|
Accessing personal macro's all the time
Thanks, I am printing it now & will try.
--
Al
"Anne Troy" wrote:
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
|