Marcos all over the place on different computers / in different documents

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

Johnnyboy5

New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy
 
Read http://www.word.mvps.org/FAQs/MacrosVBA/OrganizeMacros.htm.

You may have a problem getting your macros to be available as you move from one computer to another with just what's available on a pen drive. The only way to be sure they'll be there is to store all
the macros needed by each document *in that document*, because you won't have the document's base template or your global templates available except on your own computer. Of course, that causes Word's
antivirus protection to either disable macros or pop up a message warning that you might destroy the world by enabling horrible macros, depending on the macro security setting on that particular
computer. :-(
 
As we have discussed privately, these 'documents' should be templates, and
the ones I have assisted you with are saved as templates. The macro code is
stored in those templates, so by creating new documents from them, the
macros become available (subject to the macro security set on the PC). Once
you have created the documents, the macros only remain available while they
can see the template containing them. If you transfer the document to
another PC, the template with the macros is not available to it. See also
http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy
 
Oh the relief! When I saw the thread title I thought 'Another new expression
and/or acronym -- I shall never get the hang of this...


New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy
 
As we have discussed privately, these 'documents' should be templates, and
the ones I have assisted you with are saved as templates. The macro code is
stored in those templates, so by creating new documents from them, the
macros become available (subject to the macro security set on the PC). Once
you have created the documents, the macros only remain available while they
can see the template containing them. If you transfer the document to
another PC, the template with the macros is not available to it. See alsohttp://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



New to macros  !

I am getting in a right mess with my marcos,  I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc  If I copy and paste them I get in even more
of a mess,  e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy
Click to expand...

Fair comment Graham - but the last one you kindly sent back to me had
the spelling macro missing and I tried to paste it back in and "messed
it up" but I have sat down had a stiff drink and sorted it out -
there are two marcos now safely attached to that template. I printed
the above post and will have a go this weekend to try and understand
more about sorting them out. What fun learning is, everyday can be
a school day.
 
Readhttp://www.word.mvps.org/FAQs/MacrosVBA/OrganizeMacros.htm.

You may have a problem getting your macros to be available as you move from one computer to another with just what's available on a pen drive. The only way to be sure they'll be there is to store all
the macros needed by each document *in that document*, because you won't have the document's base template or your global templates available excepton your own computer. Of course, that causes Word's
antivirus protection to either disable macros or pop up a message warningthat you might destroy the world by enabling horrible macros, depending onthe macro security setting on that particular
computer. :-(

--
Regards,
Jay Freedman
Microsoft Word MVP        FAQ:http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroupso all may benefit.








- Show quoted text -
Click to expand...

Thanks - printed it out and will have a go this weekend. Just got to
get my head around where and how these marcos work and how to use them
on fly...

John
 
New to macros  !

I am getting in a right mess with my marcos,  I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc  If I copy and paste them I get in even more
of a mess,  e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy
Click to expand...

OMG - I have just seen my bad spelling sorry I did mean MACROS lol
 
Back
Top