Thanks...that's what I was looking for!

"Kassie" wrote:

Two ways.

Click on Tools Macro, Record New Macro. Go through the motions as you would
like the macro to do it, and at the end click on Stop Recording. Now press
<Alt<F11 to go to VBE, in the left hand window, find the workbook you were
working in, double click on Module1 below that, and you will see your code.

Else, Press <Alt<F11, find the workbook you want to write the macro in,
click on Insert|Module.
Now, in the right hand window, type away?



--
kassie

never stop learning




"STEVE" wrote in message
...
That doesn't answer my question exactly does it?
Step-by-step, where do I enter a macro please?

"Kevin B" wrote:

Macros are stored in VBA Modules, or in worksheet and workbook modules.
By
default, when you record a macro it's placed in a module named Module#
where
# is the next available module number and saved with the current
workbook.

To make macros available to all workbooks you can place them in a
workbook
named PERSONAL.XLS, which opens up in the background each time you start
Excel, but is hidden from view. Click WINDOW and select UNHIDE to
actually
view the PERSONAL workbook.


--
Kevin Backmann


"STEVE" wrote:

Where exactly do you put them?