Running Macro's saved in Global Template

[Suzanne]

Hi,

I've added a few Macros to the Enterprise Global Template.

When running the macro's in a published scheduled, I have found I also need
to open Enterpise Global to prevent the following error message.

Run-Time error '1004':
Application-defined or object-defined error.

We have some people who have access to the Project Server but not the
Enterpise Global File who would like to use the global macro's. Is there a
way they can access the macros without me increasing there security settings
or adding macros to there ?

We also have another issue where one project on the server has a Microsoft
Visual Basic error message on opening 'File not Found'. The macro security
setting for this individual project is low, if we change to high we can open
minus errors. Obviously this is one solution to our problem, however we would
like to find the source of the problem, checked DLL's, but hoping for other
ideas to troubleshoot this one.

Thanks!
Suzanne

 

[Rod Gill]

What is the code that causes the error?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Mark]

Hi Suzanne,

Did you ever find the solution to the 'file not found' problem?

Regards

Mark