Conversion to XP causing problems

L

Lynniebud

Hi all,

My office is in the process of converting from Windows NT to Windows XP. We
have a lot of spreadsheets which should kick off a macro automatically on
opening, and while they work in NT they don't in XP. The workbook opens, but
the macro doesn't run. What do I need to change to get this working?

Thanks in advance,

Lynniebud
 
J

joel

Start by looking at the security settings in Excel. Should be set to medium

Excel worksheet menu : Tools - Macro - Security

Older macros from excel 2000 use a On Open event. New macros use workbook
open Events. The On Open will work in excel 2003 and later, but workbook
Open doesn't work in older versions of Excel. Sometimes older macros create
errors in new versions of excel and have to be modified.

If you still have problems then try to change the Error trapping options in
VBA menu

Tools - Options - General

Another thing you may have to do is comment out the ON ERROR statements in
the VBA code to help you find the errors.
 
L

Lynniebud

Thanks very much Joel!

Lynniebud






joel said:
Start by looking at the security settings in Excel. Should be set to medium

Excel worksheet menu : Tools - Macro - Security

Older macros from excel 2000 use a On Open event. New macros use workbook
open Events. The On Open will work in excel 2003 and later, but workbook
Open doesn't work in older versions of Excel. Sometimes older macros create
errors in new versions of excel and have to be modified.

If you still have problems then try to change the Error trapping options in
VBA menu

Tools - Options - General

Another thing you may have to do is comment out the ON ERROR statements in
the VBA code to help you find the errors.
Click to expand...
 
Top