VBA need help with stopping popup message box...

L

Lidsavr

Active Member
Joined
Jan 10, 2008
Messages
330
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Try like this

Code: 
Application.DisplayAlerts = False
'
'delete sheet
'
application.DisplayAlerts = True
 
Upvote 0
VoG said:
Try like this

Code: 
Application.DisplayAlerts = False
'
'delete sheet
'
application.DisplayAlerts = True
Click to expand...

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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Table issue with VBA
Replies
0
Views
68
Mike2
M
6StringJazzer
  • Question
Constantly getting "Out of memory" messages when VBA window is open
Replies
7
Views
226
6StringJazzer
6StringJazzer
J
  • Question
Vba code to display the 3 values contained in a specified column in a message box
Replies
1
Views
275
rlv01
R
S
  • Question
Pop Up Message Box - Out of Date items in a Column
Replies
1
Views
722
GlennUK
G
B
  • Question
Can't Exit Desing Mode because Control 'xxxx' can not be created
Replies
1
Views
231
ktwwtk
K

Forum statistics

Threads
1,214,998
Messages
6,122,639
Members
449,093
Latest member
Ahmad123098

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top