+ Reply to Thread
Results 1 to 3 of 3

Skipping confirm

  1. #1
    Greg
    Guest

    Skipping confirm

    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



  2. #2
    Tom Ogilvy
    Guest

    Re: Skipping confirm

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

    --
    Regards,
    Tom Ogilvy

    "Greg" <[email protected]> wrote in message
    news:[email protected]...
    > 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
    >
    >




  3. #3
    Greg
    Guest

    Re: Skipping confirm

    Thankyou again

    Greg



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1