Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |