Board index MS EXCEL

Skipping confirm

Skipping confirm

Post by Greg » Wed, 23 Feb 2005 21:10:27


I have in my workbook a button which does everything i want delete the
hyperlink but when it comes to removing the sheet I want it asks meto
confirm

How do I avoid this pop-up

Here is the code I have so far

Private Sub CommandButton1_Click()
Sheets("TITLE PAGE").Select
Range("A5").Select
Selection.Delete Shift:=xlUp
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets("PRIVATE INSURANCE").Select
ActiveWindow.SelectedSheets.Delete
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("TITLE PAGE").Select
ADDCLIENT3.Hide
ADDCLIENT2.Show

End Sub

Thanks in advance

Greg
 
 
 
Top

Skipping confirm

Post by Tom Ogilv » Wed, 23 Feb 2005 21:58:17

application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

 
 
 
Top

Skipping confirm

Post by Greg » Wed, 23 Feb 2005 22:02:30

Thankyou again

Greg
 
 
 
Top

1. Skip confirming in Outlook when autmatic sending mail from Access

2. skip confirming

3. How to skip the "confirm-question" when running an remove-query

4. How to skip the "confirm-question" when running an remove-quer

5. skipped records- prints the first 2 skips 1, prints 2, skips 1, e

6. Can't switch off Connect Confirm and Disconnect Confirm sounds!

7. how to auto confirm the confirm dialog from web

8. DTS - by setting skip rows=1 will skip the second data row as well !!

9. Paste Special Skip Blanks not skipping blanks, but overwriting...

10. :Skip() vs :Skip(1)

11. Skip-a-gen-ophobia: fear of skipping the latest version

12. Skip Forward / Skip Backward feature still not available

13. Who ate my token? (\skip and \the\skip)

14. how does access handle skips i.e a condition control skipping ove.

15. reference row on another sheet skipping zeros but not skipping li.

All times are UTC
Board index