hi,
try this instead
Application.Dialogs(xlDialogSaveAs).Show
-----Original Message-----
I have a save button on one of my sheets. The code I
have linked to
that button uses this command:
application.dialogs.applications.getsaveasfilenam e
This brings up the right dialog box, however, when i type
in a file
name and press save, the dialog goes away and didn't save
anything.
What additional commands to I need to write into the
macro to get it to
save. Clearly I am missing something.
Thanks
--
jacksonz
----------------------------------------------------------
--------------
jacksonz's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=13728
View this thread:
http://www.excelforum.com/showthread...hreadid=262445
.