How do I transfer macros from one machine to another?

[Walter]

I have several macros that I wrote and I want to put them on a new computer I
just received.

I tried transferring the module with the code to a project, saving the
project, going to the new machine, opening the project and transferring the
module to the new machine's global. I don't get any errors and I can open
the module on the new machine and see the various procedures but they don't
show up in Tools, Macros.

Please help!

Thanks,

Walter

 

[Rod Gill]

Did you enable macros in the new PC and set macro security to medium or low?

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Walter]

Rod,

The macro security was set to medium. I started over and now it works. I
must have failed to copy all the procedures. The code in the module I setup
first seemed to only contain Private Subs. Are private subs not visible as
macros that can be executed? It makes sense that they wouldn't be.

Walter