D
dhputnam
I have a number of spreadsheets with code in the Workbook_Open sub. This
code is not being executed when the spreadsheets are opened. Even when I put
a break point at the beginning of the code, the breakpoint is never
triggered, which leads me to believe that the sub is never being called. The
Workbook_Activate sub has the same problem.
The spreadsheets were created with Excel 2000 and were modified and saved
with Excel 2003. I did not have the problem prior to saving them with Excel
2003. If I create a new spreadsheet in Excel 2003 and copy the worksheets
and VB code into the new spreadsheet, the Workbook_Open sub is called and the
code is executed. However, all the formulas and pivot table references still
point to the original spreadsheet, and it is way too much trouble to try to
change all of these.
Does anyone have any suggestions about how to fix the original spreadsheets
to get around this problem?
Thanks.
code is not being executed when the spreadsheets are opened. Even when I put
a break point at the beginning of the code, the breakpoint is never
triggered, which leads me to believe that the sub is never being called. The
Workbook_Activate sub has the same problem.
The spreadsheets were created with Excel 2000 and were modified and saved
with Excel 2003. I did not have the problem prior to saving them with Excel
2003. If I create a new spreadsheet in Excel 2003 and copy the worksheets
and VB code into the new spreadsheet, the Workbook_Open sub is called and the
code is executed. However, all the formulas and pivot table references still
point to the original spreadsheet, and it is way too much trouble to try to
change all of these.
Does anyone have any suggestions about how to fix the original spreadsheets
to get around this problem?
Thanks.