Since move into Active Directory, Excel macros won`t run

[dannydanny]

Hi,

We just moved our users from a NT4 domain into AD. (W2k Pro Sp3, Office 2000 SP3).
Since then, when I open an Excel file with macros, the usual prompt that asks me if I want to open the file with the macros active or disabled does not appear. Then when I try to manually run the macro, I get a pop up message saying the macros are disabled and I have to refer to documentation to activate the macros!?!

I thought it was a AD group policy thing, but my superiors who manage group policy swears there is nothing that prevents macros in Excel from being executed. So where in Excel can I activate disabled macros? Or is it really an AD group policy restriction?

Thanks for any info,
Danny.

 

[dgh2000]

What is the level of the Macro security that is set? If you updated the sevice packs on the machines I think this might have changed the default. If the security (tools/macro/security) is set to high then it won't prompt and unless it is from a source you have designated trusted then it won't run. You can change it to Medium to get the prompt back.

Dave