Upgraded to Excel 2002

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
Chris said:
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.
Click to expand...

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 *
 
Rob,

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

Thanks,
Chris
-----Original Message-----


Hi Chris,

Before you open your workbook, choose
Click to expand...
Tools/Macro/Security from the menu
 
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]
 
Back
Top