Upgraded to Excel 2002

[Chris]

I have created several programs in Excel 2000. I've just
upgraded to Excel 2002 (Office XP) and now the programs
will not run. I can see the macros but they don't run.
Any help would be great.

Thanks.

 

[Rob Bovey]

I have created several programs in Excel 2000. I've just
upgraded to Excel 2002 (Office XP) and now the programs
will not run. I can see the macros but they don't run.

Hi Chris,

Before you open your workbook, choose Tools/Macro/Security from the menu
and make sure that your macro security setting is Medium. The default in
Excel 2002 is High, which disables all macros without warning you about it.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Guest]

Rob,

The settings are set at Medium. Still don't work.

Thanks,
Chris

-----Original Message-----


Hi Chris,

Before you open your workbook, choose

Tools/Macro/Security from the menu

 

[Jake Marx]

Hi Chris,

By "don't run", do you mean you get compile errors, syntax errors, or does
the code not execute? Are your non-event-related subroutines and functions
located in Standard Modules?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]