Over Riding Delete Prompt, How? (easy money here)

lukec · Apr 25th, 2002, 10:45 AM

My problem is pretty straight forward. I am providing my own custom MsgBox like ("Delete?", vbYesNo) and on yes it executes:

Sheets(ActiveSheetNumber).Select
ActiveWindow.SelectedSheets.Delete

While on no it Ends the macro. Problem is when they press yes, a default delete comfirmation comes up, and if the push cancel here it causes an error in my macro. Can I get rid of this confirmation? (.. I would be willing to use it as an extra warning if I could make the cancel in the default exit my macro.)

Thanks a bunch,
Luke Campbell

Ricky Morris · Apr 25th, 2002, 11:11 AM

Try:
application.displayalerts = False

bergy · Apr 25th, 2002, 11:17 AM

Hi,

Try adding this line of code before the 'delete' line:

Application.DisplayAlerts = False

It should work.

lukec · Apr 25th, 2002, 11:45 AM

Works great. Thanks fellows.

Luke Campbell

Apr 25th, 2002, 11:11 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try: application.displayalerts = False __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 10:45 AM	#1
lukec New Member Join Date: Apr 2002 Posts: 11	My problem is pretty straight forward. I am providing my own custom MsgBox like ("Delete?", vbYesNo) and on yes it executes: Sheets(ActiveSheetNumber).Select ActiveWindow.SelectedSheets.Delete While on no it Ends the macro. Problem is when they press yes, a default delete comfirmation comes up, and if the push cancel here it causes an error in my macro. Can I get rid of this confirmation? (.. I would be willing to use it as an extra warning if I could make the cancel in the default exit my macro.) Thanks a bunch, Luke Campbell

Apr 25th, 2002, 11:17 AM	#3
bergy Board Regular Join Date: Apr 2002 Posts: 112	Hi, Try adding this line of code before the 'delete' line: Application.DisplayAlerts = False It should work.

Apr 25th, 2002, 11:45 AM	#4
lukec New Member Join Date: Apr 2002 Posts: 11	Works great. Thanks fellows. Luke Campbell