Macros

[caring4211]

I've added macros to my document using Visual Basic Editor. On this one
particular document, I have written about 50 macros. All of the macros are
working on my machine. I have forwarded the document to another person who
can not get the macros to work. Their computer has the security level set to
medium, tells it to enable macros, and the macros do not work. They went in
under Macros and clicked "Run" for the first Macro that now works. I can't
believe that they would need to click each one for this to work. What are we
doing wrong?

 

[Anne Troy]

How were they running the macros otherwise, caring?
*******************
~Anne Troy

www.OfficeArticles.com

 

[Doug Robbins]

That is the normal way of running macros (unless one macro was calling other
macros).

How did you invoke them yourself? What are the macros intended to do?

--
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

 

[Jef Gorbach]

Could it be an unavailable reference problem? (Word: Tools; Macros; Macro
Editor; Tools; References)

 

[caring4211]

I created a form with check boxes. If a person answers "no" to a checkbox,
they can skip the details of the question and skip to the next question. So
I created macros for each "no" checkbox to tell it to skip to the next
question if the "no" box were checked. When I protect the document, it works
perfect. But if I forward it to someone, even though they tell it to enable
macros, it still doesn't work on their computer.

 

[caring4211]

Doug,
I'm new to Macros and I think that you are on the right track to fixing my
problem. It sounds like from what you are saying is that all my Macros need
to be "linked" in order to run through the entire form. Example, my first
macro is set that if the "no" box is marked in the first question, then the
form skips to the second question rather than continuing through the first
question. My next macro is set that if the "no" box is marked in the second
question, then it should skip to the third question etc. However, when I
forward this only the first question works. Do I need "call" in there and if
so how do I do that? What do I say in the macro?

 

[Doug Robbins]

Are you sure that all of the macros ended up in the document and that some
of them are not in your normal.dot template?

--
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

 

[caring4211]

Doug,
On the left side of Visual Basic, it shows Normal and then it shows Project.
Under Project to shows Microsoft Word Objects and then ThisDocument. When
this is clicked all of the Macros are showing.

Any more ideas? Help!!!

 

[Doug Robbins]

That's you problem. The macros are in YOUR normal.dot template. What you
should do is create a template that you provide to the other users and have
the macros in that template.

--
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