| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I stop a message from appearing when deleting using VB?
I am using the delete method in VB to delete a sheet that is being copied in
redundancy. How in the world do I stop Excels default message from appearing and use my own? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I stop a message from appearing when deleting using VB?
look in the help index for DISPLAY ALERTS
-- Don Guillett Microsoft MVP Excel SalesAid Software "Silvertoe" wrote in message ... I am using the delete method in VB to delete a sheet that is being copied in redundancy. How in the world do I stop Excels default message from appearing and use my own? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I stop a message from appearing when deleting using VB?
Hi,
Application.DisplayAlerts = False Worksheets("MySheet").Delete Application.DisplayAlerts = True Mike "Silvertoe" wrote: I am using the delete method in VB to delete a sheet that is being copied in redundancy. How in the world do I stop Excels default message from appearing and use my own? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book | Excel Programming | |||
| stop False from appearing | New Users to Excel | |||
| can I stop the EULA message appearing every time I start Excel? | Excel Discussion (Misc queries) | |||
| Stop "save changes" message appearing | Excel Programming | |||
| how do I stop this appearing.......#DIV/0! | New Users to Excel | |||
Linear Mode
