Duncan, not sure but see if something like this will work for you, assign it
to a button on the sheet, it will not bring up the save as dialog but it
will name the sheet
Sub Save_Sheet()
'saves the sheet with Week start date
'and the valve in cell A1 to my documents
Dim MyName As String
sPath = "C:\My Documents\"
MyName = "Week start date " & Range("A1") & ".xls"
ActiveWorkbook.SaveAs Filename:=sPath & MyName
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
duncan said:
I am trying to use the value of a cell "week start date" to be
automatically entered into the save as dialog for unique filenames.Is this
possible?
