I have a large workbook with hundreds of sheets. I have created a button on
each sheet to display a userform. On this userform, the user is allowed to
print, preview, exit, return to the previous menu, and Save As (fyi... I have
eliminated all toolbars and menus from the workbook). I would like the Save
As command button to copy the worksheet into a new workbook and then prompt
the user to save the file in any location and with any name he/she wants. I
can copy the worksheet, but I am having trouble with the Save As function.
Can someone point me in the right direction? Thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200604/1