Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls only partially effective?
I have a need to apply macros to older spreadsheets to make them current
(update data). Everything I've read says to place the macros in a file called personal.xls and place this spreadsheet in the XLSTART folder on a given PC. I did this, and all of my VBA code works-- but ONLY for the default workbook loaded with Excel. The subroutines (Workbook_Open, Workbook_NewSheet, etc) do not fire for any subsequently opened workbooks. This defeats the purpose. Does anybody know a solution? Essentially, I need certain macros to run on ALL workbooks opened. Thanks all, Randall Arnold |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls only partially effective?
It sounds like you want not just workbook events, but application events.
Take a look a Chip Pearson's site for lots more information (and a sample workbook): http://www.cpearson.com/excel/AppEvent.htm Randall Arnold wrote: I have a need to apply macros to older spreadsheets to make them current (update data). Everything I've read says to place the macros in a file called personal.xls and place this spreadsheet in the XLSTART folder on a given PC. I did this, and all of my VBA code works-- but ONLY for the default workbook loaded with Excel. The subroutines (Workbook_Open, Workbook_NewSheet, etc) do not fire for any subsequently opened workbooks. This defeats the purpose. Does anybody know a solution? Essentially, I need certain macros to run on ALL workbooks opened. Thanks all, Randall Arnold -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls only partially effective?
Excel is working correctly.
You will either have to copy the macros to the other workbooks Workbook_Open or run the macros another way, such as from a button. Regards BrianB ========================================== "Randall Arnold" wrote in message ... I have a need to apply macros to older spreadsheets to make them current (update data). Everything I've read says to place the macros in a file called personal.xls and place this spreadsheet in the XLSTART folder on a given PC. I did this, and all of my VBA code works-- but ONLY for the default workbook loaded with Excel. The subroutines (Workbook_Open, Workbook_NewSheet, etc) do not fire for any subsequently opened workbooks. This defeats the purpose. Does anybody know a solution? Essentially, I need certain macros to run on ALL workbooks opened. Thanks all, Randall Arnold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What would be the most effective way to do this? | Excel Worksheet Functions | |||
Make your chart more effective | Charts and Charting in Excel | |||
More effective than DAYS360? | Excel Worksheet Functions | |||
Effective Rate of Return | Excel Discussion (Misc queries) | |||
effective gross income | Excel Worksheet Functions |