Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application screenupdating not working for everything?
Hi guys
I have a VBA program which copies a sheet tab multiple times then deletes the original tab (the template tab). I've got Application.ScreenUpdating set to false, but I still get this error when the code reaches the deletion stage: "The selected sheet(s) will be permanently deleted. * To delete the selected sheets, click OK. * To cancel the deletion, click Cancel." Is there any way I can get rid of this as it's damn annoying when trying to automate everything and I have to click this 30+ times. Thanks Kai |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application screenupdating not working for everything?
try
application.displayalerts=false -- Don Guillett Microsoft MVP Excel SalesAid Software "Kai Smith" wrote in message ... Hi guys I have a VBA program which copies a sheet tab multiple times then deletes the original tab (the template tab). I've got Application.ScreenUpdating set to false, but I still get this error when the code reaches the deletion stage: "The selected sheet(s) will be permanently deleted. * To delete the selected sheets, click OK. * To cancel the deletion, click Cancel." Is there any way I can get rid of this as it's damn annoying when trying to automate everything and I have to click this 30+ times. Thanks Kai |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application screenupdating not working for everything?
Fantastic!
Thanks very much Don, works a charm. Regards "Don Guillett" wrote in message : try application.displayalerts=false -- Don Guillett Microsoft MVP Excel SalesAid Software "Kai Smith" wrote in message ... Hi guys I have a VBA program which copies a sheet tab multiple times then deletes the original tab (the template tab). I've got Application.ScreenUpdating set to false, but I still get this error when the code reaches the deletion stage: "The selected sheet(s) will be permanently deleted. * To delete the selected sheets, click OK. * To cancel the deletion, click Cancel." Is there any way I can get rid of this as it's damn annoying when trying to automate everything and I have to click this 30+ times. Thanks Kai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
application.screenupdating = false not working | Excel Programming | |||
Screen still changes. Why ? (Application.Screenupdating = False not working | Excel Programming | |||
'Application.ScreenUpdating = False' isn't working | Excel Programming | |||
Application.screenupdating is not working in Excel 2002 though it. | Excel Programming |