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

Sub SaveDeal()

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

End Su

--
Ralmon
-----------------------------------------------------------------------
Ralmond's Profile: http://www.excelforum.com/member.php...fo&userid=2007
View this thread: http://www.excelforum.com/showthread.php?threadid=34683