Distributing a Doc with Macros?

[BobZ]

So now I've developed this Word doc with control buttons and VBA code and I
need to post it so the company can download and fill it out (it's a request
form).

What's the easiest way to get around the macro security issue? Should I
just post a note at the download site telling them to either set their macro
setting to medium security and/or enable macros when prompted, or is there a
cleaner way?

--Bob

 

[BobZ]

DISREGARD THIS POST--I already posted to this group. Sorry.

 

[Jean-Guy Marcil]

BobZ was telling us:
BobZ nous racontait que :

So now I've developed this Word doc with control buttons and VBA code

"doc" = document (*.doc) or template (*.dot)?

and I need to post it so the company can download and fill it out
(it's a request form).

What's the easiest way to get around the macro security issue?
Should I just post a note at the download site telling them to either
set their macro setting to medium security and/or enable macros when
Yes.

prompted, or is there a cleaner way?

Not really... except...

If you are using a document (*.doc) parading as a template, then no, there
is no other way and you are probably asking for trouble (unless it is a
"download when you need it" type of thing).

If, on the other hand, you are using a real template (*.dot), and if you can
manage to get the people to install it in the right location then their
macro setting can stay at high. Normally, a template in the User Templates
or Workgroup Templates folders will run with its macros. (You could maybe
provide some sort of installer or script. Talk to the IT people.)

See
http://word.mvps.org/faqs/macrosvba/DistributeMacros.htm
for more on the topic.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[BobZ]

This is a document that users fill out if/when they need it to request access
to certain systems. This isn't really a "template", not a .dot file, it's a
..doc with macros embedded (to hide/unhide sections as they're selected).
So we're going to post it on the intranet. I was hoping/thinking that I
could just post the Word doc with the associated macros "attached", and as
they downloaded the doc it would provide the macros. But I'm not clear on
how this works.

I know I won't have the ability to do any install scripts or even put .dot
files on their machines, so I'm looking for the best workaround.

 

[Jean-Guy Marcil]

BobZ was telling us:
BobZ nous racontait que :

This is a document that users fill out if/when they need it to
request access to certain systems. This isn't really a "template",
not a .dot file, it's a .doc with macros embedded (to hide/unhide
sections as they're selected).
So we're going to post it on the intranet. I was hoping/thinking
that I could just post the Word doc with the associated macros
"attached", and as they downloaded the doc it would provide the
macros. But I'm not clear on how this works.

Yes, if they download the document that contains macro in its VBA project,
the macros will follow.
However, if their security is set to medium and higher, a message will pop
up to either ask them if they want to activate the macros (Medium) or to
inform then that macros have been disabled (High and higher).

There is nothing you can do about this.

I know I won't have the ability to do any install scripts or even put
.dot files on their machines, so I'm looking for the best workaround.

Sorry, but right now I cannot think of a workaround as I believe that none
exists.
You cannot circumvent macros security with macros, otherwise, it would not
be security, right?

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[BobZ]

Thanks--I just wanted to make sure I understood and wasn't missing any
options. Sounds like between your help and the others I've got a handle on
it. I'll post a message about the security settings and the users will have
to take responsibility (right now in this company that's where we're at with
this sort of thing!).

Yes, the double-edged sword of security! Keeping life interesting...

Thanks!