hi, thanks for the reply. im not too sure what you mean exactly

--
Dan
-----------------------------------------------------------------------
Danz's Profile: http://www.excelforum.com/member.php...fo&userid=1644
View this thread: http://www.excelforum.com/showthread.php?threadid=31371

go to tools=Macro=Record a New Macro

Then unprotect the sheet, (tools=Protection=Unprotect Worksheet)

go to Tools=Macro=Stop Recording

Do Alt+F11

find the macro you just recorded and look at the code.

--
Regards,
Tom Ogilvy


"Danz" wrote in message
...

hi, thanks for the reply. im not too sure what you mean exactly?


--
Danz
------------------------------------------------------------------------
Danz's Profile:
http://www.excelforum.com/member.php...o&userid=16448
View this thread: http://www.excelforum.com/showthread...hreadid=313710