"Enter" Keystroke within a Macro

[norts55]

I have a simple recorded macro to eliminate some mouse travel and keystrokes when deleting a worksheet named "Proposal Backup".

When I recorded the macro a message box popped up that states "Microsoft Excel will permanently delete this sheet. Do you want to continue?". It has a "Delete" and "Cancel" button with the "Delete" button highlighted.

During the recording process I Hit "Enter" on the Keyboard and this deleted the sheet. The problem I have is, the "Enter" does not get recorded so I have to do this every time I run the macro. Is there a way to make that part of the macro and eliminate having to strike the "Enter" key.

    ActiveWindow.ScrollWorkbookTabs Sheets:=1
    ActiveWindow.ScrollWorkbookTabs Sheets:=1
    ActiveWindow.ScrollWorkbookTabs Sheets:=1
    Sheets("Proposal Backup").Select
    ActiveWindow.SelectedSheets.Delete
    ActiveWindow.ScrollWorkbookTabs Sheets:=-1
    ActiveWindow.ScrollWorkbookTabs Sheets:=-1

 

[dmt32]

hi,

You can set DisplayAlerts property to False to suppress prompts and alert messages
while your macro is running when a msgbox would display & pause it awaiting a response.

Application.DisplayAlerts = False

'your code

'return to True
Application.DisplayAlerts = True


Dave

 

[Fluff]

How about

   Application.DisplayAlerts = False
   Sheets("Proposal Backup").Delete
   Application.DisplayAlerts = True

 

[norts55]

That worked! Thank you both very much.

 

[Fluff]

Glad we could help & thanks for the feedback