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

Take a look at the workbook before save event:

AppEvent_WorkbookBeforeSave

A recent Windows update has caused problems for many people in opening and
saving files.
See the following for possible solutions:

http://www.microsoft.com/communities...1d7&sloc=en-us

http://www.microsoft.com/communities...21d&sloc=en-us

http://www.microsoft.com/communities...a-4b9fcf741916


"mtm4300 via OfficeKB.com" wrote:

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

Many people will be using this program and it is not feasible for me to go
around to everyone's PC and disable the Windows Update.

When I click on my "Save As" command button a new workbook is created with
one sheet. If I close the copied workbook I get prompted to Save (YesNoCancel)
.. This is fine. However, when people click on a Save As button, they expect
to have their file saved already.

I would like to have the worksheet copied, and then the Excel Save As Form
appear. This will allow the user to type in a name for the workbook and also
let the user place it into any directory. Is this possible?

Patricia Shannon wrote:
A recent Windows update has caused problems for many people in opening and
saving files.
See the following for possible solutions:

http://www.microsoft.com/communities...1d7&sloc=en-us

http://www.microsoft.com/communities...21d&sloc=en-us

http://www.microsoft.com/communities...a-4b9fcf741916

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
[quoted text clipped - 4 lines]
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