I'm a novice at macros and need some help. I need a marco that deletes a sheet in an active excel workbook. I recorded a macro, but it requires user intervention (I must click on "delete" in the dialog box that pops up). Recording the macro does not record my clicking in the dialog box. How can I delete the sheet without user intervention
Visual Basic for Applications (ExCel)
Hot Topic
- Is it possible ?
- Problem with v6 control in vb.net
- how to add a "spinning icon" while my program is running
- how to add a flash ocx
- Making a picturebox have a transparent background
- VB6 to .NET
- terminate vb.net console application
- (NEWB) Null exceptions
- Start application as Administrator.
- Migrating from Ms Access to SQL Server 2000
Visual Basic
- Force re-parse of syntax....
- How do I calculate the appropriate font size to fit a string within a given area?
- Splash Screen Question
- FindWindow
- Is it possible to generate a class Library using CodeDom?
- VS2005 Release Snippet Editor?
- Error Created when opening beta 1 file in beta 2
- A complex coding for me
- Bug of the century?
- Can't run SnippetEditor.exe
Visual Basic for Applications (ExCel)
zhaorui
Worksheets("Sheet3").Delete
Application.DisplayAlerts = True