These two sites have good information on how to create a macro.

David McRitchie
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Tushar Mehta
http://www.tushar-mehta.com/excel/vb...rder/index.htm

If you wish to share your macros, here are a couple of links that
offer solutions.

http://www.google.com/groups?hl=en&l...628a6f4&rnum=6
http://www.google.com/groups?hl=en&l...3622aa&rnum=16
http://www.google.com/groups?hl=en&l...719adb4&rnum=1

I usually transfer by exporting the module that contains the macros
and then importing the module.


HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I'd like to create a simple macro that I can give to other
people and that they can load and assign to a button. How
do I do that without creating a project? Or do I have to
create a project? The macro I have in mind consists of
just a few lines I need to automate a couple of processes,
nothing fancy.

mike