Shirley,

Go to record a macro as normal, saving to Personal.xls, but as soon as the
record starts, stop it. Then goto menu ToolsMacroMacros..., find the
macro, Edit and paste that code over it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shirley Munro"
wrote in message
news:Shirley.Munro.1uoo6d_1125583528.3199@excelfor um-nospam.com...

The code Bob has sent me works just fine but I am not sure how to record
this using the usual Tools, Macro, Record New Macro and making it
available in the Personal Macro Workbook

Shirley


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile:
http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=401070