If you want to record a macro, select Tools, Macro, Record New Macro,
select a name, and then start recording the steps you want. Select
Tools, Macro, Stop recording to finish (if the small 'stop' is lost).

Select Tools, Macros, Macro, select your macro and EDIT to see the
code.

Hope this helps

--


CBrausa Wrote:
I have followed the steps in my Excel book on "Using the Macro
Recorder", I get to step 10. then it doesn't make sense.
10. Double click the VBA module that contains your recorded code (at
this point I haven't recorded because I don't know where to or How to).
...Note that this is a Sub procedure in a worksheet formula. If you
examine the code, however, you'll see a reference to the UserName
property. You can use this information when creating a Function
procedure. For example, the following Function procedure uses the
UserName property. This function, when used in a worksheet formula,
returns the name of the user. ...


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=539837