| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.EnableEvents = False not working
Hello- I have some macro language that deletes a sheet which will always have data on it. I don't want to have to confirm the popup message "Data may exist...", so I put in the Application.EnableEvents = False language. Thing is, the prompt still comes up! Any ideas? I'm using Excel 2002 if that makes a difference. Language below. Thanks a bunch! Windows(FileName).Activate Sheets(DeleteSheet).Select Application.EnableEvents = False ActiveWindow.SelectedSheets.Delete Application.EnableEvents = True |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.EnableEvents = False not working
You want: Application.DisplayAlerts = False HTH Otto "modo8" wrote in message ... Hello- I have some macro language that deletes a sheet which will always have data on it. I don't want to have to confirm the popup message "Data may exist...", so I put in the Application.EnableEvents = False language. Thing is, the prompt still comes up! Any ideas? I'm using Excel 2002 if that makes a difference. Language below. Thanks a bunch! Windows(FileName).Activate Sheets(DeleteSheet).Select Application.EnableEvents = False ActiveWindow.SelectedSheets.Delete Application.EnableEvents = True |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.EnableEvents = False not working
I think you want Application.DisplayAlerts = False 'The code Application.DisplayAlerts = True "modo8" wrote in message ... Hello- I have some macro language that deletes a sheet which will always have data on it. I don't want to have to confirm the popup message "Data may exist...", so I put in the Application.EnableEvents = False language. Thing is, the prompt still comes up! Any ideas? I'm using Excel 2002 if that makes a difference. Language below. Thanks a bunch! Windows(FileName).Activate Sheets(DeleteSheet).Select Application.EnableEvents = False ActiveWindow.SelectedSheets.Delete Application.EnableEvents = True |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| application.EnableEvents = false not disabling events | Excel Programming | |||
| Application.Enableevents = False doesn't stop all events? | Excel Programming | |||
| preventing Application.EnableEvents = False | Excel Programming | |||
| Application.EnableEvents = False not working | Excel Programming | |||
| Problems with BeforeSave and Application.EnableEvents = False | Excel Programming | |||
Linear Mode
