Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete sheet code
Hi,
Using the VB recorder I got a code to delete a sheet that is; Sheets("Machines").Select ActiveWindow.SelectedSheets.delete It runs and works. One small issue is that it asks Are you sure you want to delete this sheet? The user must choose yes before it continues. Can I disable the need to ask this question - once the user hits the button it deletes, no questions? Thanks LiAD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete sheet code
Application.DisplayAlerts = False
Sheets("Machines").Delete Application.DisplayAlerts = True If this post helps click Yes --------------- Jacob Skaria "LiAD" wrote: Hi, Using the VB recorder I got a code to delete a sheet that is; Sheets("Machines").Select ActiveWindow.SelectedSheets.delete It runs and works. One small issue is that it asks Are you sure you want to delete this sheet? The user must choose yes before it continues. Can I disable the need to ask this question - once the user hits the button it deletes, no questions? Thanks LiAD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to delete shapes each time a sheet is deactivated | Excel Programming | |||
What is the VBA code to delete a sheet without warning message? | Excel Discussion (Misc queries) | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
Delete sheet code | Excel Programming | |||
Code to not display delete sheet alerts | Excel Programming |