Macro question

[rmcove]

I am trying to get my macro to delete unwanted tabs. The tabs are needed for
links, but after I break the links I want to delete the tabs so that the file
size will be minimal.

The problem is my macro works, but will not confirm the delete and I just do
not know the command needed.

Thanks,
rmcove

 

[Kevin B]

Is there an Application.DisplayAlerts = False line somewhere in your code?

If there is you can either remove it or set the False value to True.

If that's not the case I suggest you add another post to this thread with
your macro code in it, and for good measure indicate which version of Excel
you're using too.

Hope this helps...

 

[Eduardo]

Hi,

popUp = MsgBox("Are you sure you want to delete the Tab", vbYesNo +
vbQuestion, "MY POP-UP")
If popUp = vbYes Then
' your statement
Else
Exit Sub ' Quit the macro
End If

 

[rmcove]

Here is the section from my macro


Sheets("MASTER INFO").Select
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.Delete


a window then pops up asking me to confirm the delete and I would like the
macro to have a line that confirms the delete/enter?

 

[Mike H]

application.displayalerts=false
Sheets("MASTER INFO").delete
application.displayalerts=true

Hope this helps

Mike

 

[rmcove]

Thank you Mike,

That worked great.

--
rmcove

application.displayalerts=false
Sheets("MASTER INFO").delete
application.displayalerts=true

Hope this helps

Mike