How to set Macro security to Medium level automatically

[Help]

I have a macro that updates the project at close. There
are 150 users that are using Project Pro 2002 SP1. During
SP1 upgrade, the Macro security got reset to "High". Is
there a way that the Macro security can be set to Medium
for all the users automatically. Setting it to low on
Enterprise gobal does not seem to work because it is
probably a local setting.

Also, is there a VBA method/procedure that run the Macro
automatically without opening or closing each plan. i.e.
Macro updates all the project plans in Project Server
without opening them in Project Pro.

Please advise.

Thanks!

 

[JackD]

I believe that you can set this through policies, but I don't know enough
about that to tell you how to do it.
You could ask in one of the windows groups (maybe there is one on
administration?) to see if you can get an answer there.

As for running a macro on a plan which is not open, well, that is not
possible. You can work with the database and make changes, but the project
is not recalculated until the project is opened in Project Pro.

-Jack

 

[John]

Jack,
This is a little out of my knowledge base but if the code were in VB
instead of VBA it could run independently, right? And, if the poster's
main concern about opening and closing the plans is a visual one,
couldn't they be updated in the background (i.e. visible = false)?

Just a thought.
John

 

[JackD]

That is surely possible, however I didn't take the problem as being a visual
one.
The basic problem is that you can't use VBA code to set the security level -
otherwise malicious code would not be prevented from modifying the security
level - this defeats the whole purpose of the security level.

-Jack

 

[Earl Lewis]

The macro security thing can probably only be handled with a domain policy change - which is only possible if all the workstations login to a Windows domain that uses domain policies.

As far as your second question goes, what is it that the macro is doing? I'm assuming this question is NOT related to changing the macro security level. If you need to make sweeping changes throughout all your project plans you COULD do this directly in the database. IF, and only IF, you know exactly what your change needs to be and how it may affect related tables and data.

Post more about the specifics of your change and maybe a more precise answer can be given.

Earl

I have a macro that updates the project at close. There
are 150 users that are using Project Pro 2002 SP1. During
SP1 upgrade, the Macro security got reset to "High". Is
there a way that the Macro security can be set to Medium
for all the users automatically. Setting it to low on
Enterprise gobal does not seem to work because it is
probably a local setting.

Also, is there a VBA method/procedure that run the Macro
automatically without opening or closing each plan. i.e.
Macro updates all the project plans in Project Server
without opening them in Project Pro.

Please advise.

Thanks!