Question "Save As" dialog box... (-:
What code would be running while the dialog is visible. The beforesave
event has ended before the dialog is displayed.
Use the
Application.GetSaveAsFilename
dialog to return that information to you and then you can determine whether
to save the file or not.
--
Regards,
Tom Ogilvy
"blc" wrote in message
...
Hello all,
Anyone have any idea how I can get a reference to the "Save As" dialog box
that is instantiated when a user clicks the "Save As" button on the Excel
MAIN toolbar???
I would like to be able to determine what the new filepath and filename
will be in the Workbook_BeforeSave event before the Save occurs...
Thank you very much,
blc
|