| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Save vs SaveAs in BeforeSave
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting Save vs SaveAs in BeforeSave
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 "Aaron" wrote in message ... | 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting Save vs SaveAs in BeforeSave
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 "Aaron" wrote in message .. | 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling SaveAs and Save? | Excel Discussion (Misc queries) | |||
| Save and Saveas Greyed out on tool bar and file menu | Setting up and Configuration of Excel | |||
| BeforeSave sub won't save another workbook when triggered by another event sub | Excel Programming | |||
| using SaveAs to save 'only' one sheet from one book to a new file | Excel Programming | |||
| VBA - BeforeSave - NEED HELP | Excel Programming | |||
![Aaron[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
