If you want the code to execute when you close the workbook, just name it
auto_close().

You may want to be more specific about what G5 you're using:

.... & worksheets("sheet3").range("g5").value & ...





Ralmond wrote:

ok so here it is now, instead of having it on auto-run how do i set it
up to run after cell g5 is populated?

Sub SaveDeal()

Workbooks("book1").SaveCopyAs Filename:="C:\Documents and
Settings\ralmond\Desktop\DEALS\" & Range("G5").Value & ".xls"

End Sub

--
Ralmond
------------------------------------------------------------------------
Ralmond's Profile: http://www.excelforum.com/member.php...o&userid=20070
View this thread: http://www.excelforum.com/showthread...hreadid=346835

--

Dave Peterson