Project 2002 and Excel Macros

[Roberta]

I have a problem with the installation of Project 2002 and BW from SAP. The
Bex Analyzer uses an Excel macro to access SAP. However, once I install
Project 2002, the macro display message: Enable/Disable Macros, does not
appear and the macro does not work.

I have computers using only Office 2000. The only way I can make this work
is by using Detect and Repair from Excel. However, I do not have Office
self-healing working yet.

Can anyone help me? I would be most appreciative.

Thanks,

Roberta

 

[Jason-W]

Hi,

Maybe Project 2002 reset the macro security level up
to "high"? Check under Tools -> Macro -> Security... and
make sure it is set to "medium".

HTH
--Jason

 

[Jason-W]

Hi,

Double check your macro security settings under Tools ->
Macro -> Security... and make sure it is set to "Medium".
It may have been reset to "High" when you installed
MSP2000 or one of the other programs.

HTH
--Jason