Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skipping confirm
application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Greg" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skipping confirm
Thankyou again
Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Confirm Autofilter off | Excel Programming | |||
Confirm deletion | Excel Programming | |||
Macro : confirm Delete | Excel Programming | |||
Please confirm the following bug in Excel | Excel Programming |