Detecting Save vs SaveAs in BeforeSave

G

Guest

Hi

Is it possible to determine the type of Save requested from a user i.e Whether it was 'Save' or 'SaveAs' in the BeforeSave event

Thanks
Aaron
 
J

Jim Rech

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

SaveAsUI is False in a Save and True with a SaveAs.

--
Jim Rech
Excel MVP
| Hi,
|
| Is it possible to determine the type of Save requested from a user i.e
Whether it was 'Save' or 'SaveAs' in the BeforeSave event.
|
| Thanks,
| Aaron
 
G

Guest

Thanks

----- Jim Rech wrote: ----

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean

SaveAsUI is False in a Save and True with a SaveAs

--
Jim Rec
Excel MV
| Hi

| Is it possible to determine the type of Save requested from a user i.e
Whether it was 'Save' or 'SaveAs' in the BeforeSave event

| Thanks
| Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After SaveAs events - are there any? 2
SAveAs executes combobox code 3
GetSaveAsFilename 2
Save a BackUp of Workbook 1
Get the Excel Filename after a save 5
identify 'save as' of the commandbar 'worksheet menu bar' 2
Make "BeforeSave" event supply a default path and file name? 1
BeforeSave sub won't save another workbook when triggered by another event sub 1

Top