VBA need help with stopping popup message box...

[Lidsavr]

I am running Excel 2007.

I know I have seen the answer to my question on this forum in the past, but I cannot find it with a search.

When I delete a worksheet during the execution of code a popup message box pops up asking me if I want to delete the sheet.

How can I stop the popup message box from appearing and just have it delete the sheet?

Thank you,

Lidsavr

 

[VoG]

Try like this

Application.DisplayAlerts = False
'
'delete sheet
'
application.DisplayAlerts = True

 

[Lidsavr]

VoG,
Thank you very much!

Lidsavr

 

[VBABEGINER]

Try like this

Application.DisplayAlerts = False
'
'delete sheet
'
application.DisplayAlerts = True

Dear Vog Sir and all the board members,

Very good aftrenoon..

With respect the above query i have the similar question.

I want stop popped up messages from the other website. That mean..I have a code. When that code, I have using one website to be open. But that website gives me popped up message. That i guess i dont have google updated or chrome. But it giving me an popped up message.

I want to ignore that popped up.

How do i get that...could you please advise me.

 

[VBABEGINER]

Could anyone help on this discussion..