Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Alert
I've put this in my 'This Workbook' space. But it doesn't seem to be
working. Any ideas? Private Sub Workbook_BeforeClose(Cancel As Boolean) 'Disables 'Do you want to save changes?' Alert Before Close Application.DisplayAlerts = False End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Alert
Hi
What are you trying to do ? If you want to close the workbook without saving the workbook and no alerts, then use the below in your "Workbook_BeforeClose" event (You don't have to turn off the alert): Thisworkbook.Saved=True. Hopes this heps. --- Per On 6 Maj, 20:52, wrote: I've put this in my 'This Workbook' space. *But it doesn't seem to be working. *Any ideas? Private Sub Workbook_BeforeClose(Cancel As Boolean) 'Disables 'Do you want to save changes?' Alert Before Close * * Application.DisplayAlerts = False End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Alert
On May 6, 8:00*pm, Per Jessen wrote:
Hi What are you trying to do ? If you want to close the workbook without saving the workbook and no alerts, then use the below in your "Workbook_BeforeClose" event (You don't have to turn off the alert): Thisworkbook.Saved=True. Hopes this heps. --- Per On 6 Maj, 20:52, wrote: I've put this in my 'This Workbook' space. *But it doesn't seem to be working. *Any ideas? Private Sub Workbook_BeforeClose(Cancel As Boolean) 'Disables 'Do you want to save changes?' Alert Before Close * * Application.DisplayAlerts = False End Sub- Hide quoted text - - Show quoted text - Thanks. It worked. Any ideas why my first try didn't work? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Alert
If you want to save the workbook then put the following code:
ThisWorkbook.Save If you don't want to save then put the following: ThisWorkbook.Saved = True -- A. Ch. Eirinberg " wrote: I've put this in my 'This Workbook' space. But it doesn't seem to be working. Any ideas? Private Sub Workbook_BeforeClose(Cancel As Boolean) 'Disables 'Do you want to save changes?' Alert Before Close Application.DisplayAlerts = False End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Alert
Hi
Excel will always prompt the user to save an unsaved file before closing it. Another solution to close without saving: ThisWorkbook.Close SaveChanges:=False Regards, Per Thanks. *It worked. *Any ideas why my first try didn't work?- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Alert
On May 6, 8:37*pm, Per Jessen wrote:
Hi Excel will always prompt the user to save an unsaved file before closing it. Another solution to close without saving: ThisWorkbook.Close SaveChanges:=False Regards, Per Thanks. *It worked. *Any ideas why my first try didn't work?-- Hide quoted text - - Show quoted text - Thanks, All. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Macro Alert | Excel Discussion (Misc queries) | |||
Can you disable the macro security alert? | Excel Programming | |||
Disable the alert | Excel Programming | |||
Disable Link Alert | Excel Programming | |||
Disable alert message when merging cells?? | Excel Programming |