I am currently looking for a way to prompt users to save a copy of a
worksheet into a location of their choosing (same as doing "FIle", "Save
As"). This is what i have so far:

Sub Copy_Save_OneDay_Sheet()
'
' Copy_Save_OneDay_Sheet Macro
' Macro recorded 11/17/2006 by ISD
'
'
Sheets("Roster(1 Day)").Select
Sheets("Roster(1 Day)").Copy

End Sub

Can someone help? Thanks
--
Dwayne