Gene, put it in a normal module, try this

To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is to the left of the "File" menu this will open
the VBA editor, in the left hand window click on your workbook name, go to
insert, module, and paste the code in the window that opens on the right
hand side, press Alt and Q to close this window and go back to your workbook
and press alt and F8, this will bring up a box to pick the Macro from, click
on the Macro name to run it.



--

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Gene Goldenfeld" wrote in message
...
Fred Smif wrote:

It's just like copying and pasting text:

Open the VBA (Visual Basic for Applications) editor (how you do this may
vary according to the particular version of Excel); in Excel 2003 this is
done by selecting Tools menu, Macro command, select Visual Basic Editor
from
the pop-up menu.

Copy the text of the macro you want to use. Paste the text into the VBA
macro sheet (either a new module or on the macro sheet associated with a
particular worksheet) by selecting the Edit menu, Paste command. Then
edit
the macro to suit your needs.

"Gene Goldenfeld" wrote in message
...
I want to create a macro in Excel 2000 using one already written by
someone else. but all I find are instructions to create one from
scratch
the normal keyboard/mouse way. Is there a more direct way to create
and
copy one in? The macro in question is he
http://www.cpearson.com/excel/unselect.htm. Thanks,

Gene

Thanks. What I have been clear about is that in opening VBE there are
three windows with different titles (after the WFXL2000.XLS):
-1) Print2WinFax (tools) with a macro in it
-2) ThisWorkbook (Code) with a little text
-3) Sheet1 (Code) with a little text

Not sure why WinFax is there, but which do I use?

Gene