Walter P Wrote:
Thx Bearacade, but can you put it in laments terms for me?



Ok.. so open your excel spreadsheet. Go to Tools Macros Visual
Basic Editor (or you can just press Alt + F11)

On the left side is the Project Explorer. You should see something
with the name VBAProject (-Name of your excel file-)

Click it if it is not expanded already, and double click on
ThisWorkbook. Put the code in the box that pops up.

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=563438