| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
quit without saving option
I have a program that sits on a network when the program closes it
always gives the user the option to save the file, can i stop this from happening to that when the close button is selected on my userform the file just shuts straight down thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
quit without saving option
ActiveWorkbook.Close SaveChanges:=False
or, you can try setting the Saved property to True ActiveWorkbook.Saved = True -- Regards, Tom Ogilvy wrote in message oups.com... I have a program that sits on a network when the program closes it always gives the user the option to save the file, can i stop this from happening to that when the close button is selected on my userform the file just shuts straight down thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving changes to option to apply all the time. | Excel Discussion (Misc queries) | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming | |||
| Quit Application Without Saving | Excel Programming | |||
| Quit Application Without Saving | Excel Programming | |||
Hybrid Mode
