Thread: Macro question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Macro question


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

Hope this helps

Mike



"rmcove" wrote:

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?
--
rmcove


"Kevin B" wrote:

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...
--
Kevin Backmann


"rmcove" wrote:

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