Removing the [ENABLE MACROS] [DISABLE MACROS] popup window
I appreciate the suggestion, and had already tried the Security option under
the tools/Macro menu.
It seems that when an option is set there, it doesn't take effect when you
are opening project as a COM object. Even though the tools/Macro/Security
option is set to HIGH, and when I manually load the file it just disables
the macros, which is what it should be doing. However, when I load the file
through the component that window still pops up even though the security
setting is set to high (which should just disable the macros).
With certifying the file, that might be an option if I can do that
automatically through a VB component. I'll check some more into that.
But, I really need a way to either disable the macros though the automation
component, OR remove them from the file before MS Project has opened the
file. I pretty much want to keep the Macro's from running as they will
sometimes pop up alert boxes that can in turn lockup the server.
FYI, I am using Project 2000 for this.
Thanks for your time!
Chaitanya Marvici
Quote:
> You can digitally sign the macros using a certificate or use the
> selfcert.exe utility, then set the macro sercurity to medium in Project.
> You'll then be permitted to always accept macros from the source listed on
> the dialog box. This works with the 2000 series of products, but you don't
> say which series of products you are using..
> The security option is under tools-Maco. The selfcert utility should be
> buried someplace on the Office CD or you can probably download it from
> Microsoft.
> Guy Cox, MVP Microsoft Project
> > I am currently working on a creating a COM Component that interfaces
with
> MS
> > Project on a server. Users are able to upload their MPP files and the
> > server will open and convert the MPP file to a database. However, what
> is
> > happening is if the file has Macros embedded in it, then it will pop
open
> > the [ENABLE MACROS] [DISABLE MACROS] on the server will will "lock" the
> > system till one of those 2 buttons is clicked on. I need to keep that
> > window from popping up.
> > In project itself, I have tried to set the MACRO/SECURITY level to high
to
> > keep the macros from running. It works great if I load the file through
> > project itself. However, when I use the FILEOPEN method of the project
> > component, the popup still shows up.
> > Is there anyway to either strip the VB Macros out of the file before
> opening
> > it, or allow the component to suppress that popup window?
> > Any help would be appreciated. Thanks.
> > Chaitanya Marvici
