| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.Close
Can the ActiveWorkbook.Close event be modified so that the Save dialogue
box comes up? Thanks in advance. Matthew Saxon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWorkbook.Close
"Matthew" wrote in message ... Can the ActiveWorkbook.Close event be modified so that the Save dialogue box comes up? Thanks in advance. Matthew Saxon Sorry, so that the Save dialogue box does NOT come up... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWorkbook.Close
Matthew,
Two ways...... Application.DisplayAlerts = False (turns off the alert) or ThisWorkbook.Saved = True (fools the workbook into "thinking" that it's saved whether it is or not). Use just prior to your Activeworkbook.Close John Matthew wrote: "Matthew" wrote in message ... Can the ActiveWorkbook.Close event be modified so that the Save dialogue box comes up? Thanks in advance. Matthew Saxon Sorry, so that the Save dialogue box does NOT come up... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWorkbook.Close
You only get the save Dialog if the file is not saved yet.
Do you mean Save as??? -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Matthew" wrote in message ... Can the ActiveWorkbook.Close event be modified so that the Save dialogue box comes up? Thanks in advance. Matthew Saxon |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWorkbook.Close
No, I already did a save as text file, but when I close the file it asks to
save again for some reason. MS "Ron de Bruin" wrote in message ... You only get the save Dialog if the file is not saved yet. Do you mean Save as??? -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Matthew" wrote in message ... Can the ActiveWorkbook.Close event be modified so that the Save dialogue box comes up? Thanks in advance. Matthew Saxon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
| ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
| ActiveWorkBook | Excel Discussion (Misc queries) | |||
| ActiveWorkbook.RefreshAll | Excel Programming | |||
| Activeworkbook.sendmail | Excel Programming | |||
![Matthew[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
