Deactivate a macro

[Bo Wisén]

First of all, I'm sorry for asking this in wrong newsgroup, but there's no
ng for vba/Excel on my server. But I hope that some of you who know about
macros for Word know about Excel too.

What I am trying to do is a vba macro for all Office applications that will
force the users to categorize their documents. When trying to save a
document a form will appear and they will have to select if the document is
for example public or confidential. This will be written into a bookmark in
the document.

That works fine for Word, but in Excel the users will be informed that the
document contains macros and they can click for deactivating the macro and
then they will be able to save their document without deciding if it is
public or confidential. Is there anything that can be done except setting
the macro security to low?

Thanks
Bo

 

[Jezebel]

Macro security is the same for Word as Excel.

What you're trying to do is a noble objective, but in practice it won't
work. There are too practical problems, too many users who refuse to be
pushed around, and too many instances where the users will insist on saving
their documents outside the discipline you're trying to impose.

 

[Bo Wisén]

Maybe I should tell you that this is supposed to be implemented on the
computers at my work, about 1500, where the security department has decided
that everyone has to categorize their documents and they hope it can be
solved technically to force them to that. Already today the users can only
save their documents in a few folders, for example My Documents.

Another problem: I have managed to create the word macro in 'normal.dot' and
it works fine. It's no problems to replace this file on every computer (we
are using Novadigm's Radia) but if we do so some options and autotexts will
be deleted for some users. Any solution?

Thanks
Bo

 

[Jezebel]

You are heading for a disaster on a grand scale. Do not try this. Your
security people are kidding themselves.

a) trying to get 1500 users to classify all their documents simply will not
work.

b) Yes, replacing normal.dot will screw up users' personal settings. With
1500 users, there will be many who have invested serious time in setting
Word up the way they want it. You will seriously annoy the experienced
users, and confuse the hell out of the neophytes.

All-round, this is a ill-conceived plan.

 

[Doug Robbins]

For an organization of that size, to do this sort of thing you should be
using a document management system of which their are numerous commercial
varieties.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP