Deleting sheets within a workbook

's Computer Specifications

Hello,

How do I delete sheet2, sheet3 within a open and close workbook. (I would
like to have this option) I am using Excel 2007. I don't know the VBA
coding. Any tips or website to visit I appreciate the help.

Cheers

's Computer Specifications

Look in VBA help under Delete Method. Alt + F11 to open the VBE then click
the blue circle with a question mark to open the help panel.

"CAM" wrote:

> Hello,
>
> How do I delete sheet2, sheet3 within a open and close workbook. (I would
> like to have this option) I am using Excel 2007. I don't know the VBA
> coding. Any tips or website to visit I appreciate the help.
>
> Cheers
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA	Amaxwell	Microsoft Excel Worksheet Functions	4	17th Aug 2006 06:23 AM
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?	Dmitry	Microsoft Excel Discussion	6	29th Mar 2006 12:43 PM
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?	StargateFanFromWork	Microsoft Excel Programming	6	26th Jan 2006 06:31 PM
Deleting All Sheets Other than specified from a workbook	Nic@Rolls-Royce	Microsoft Excel Programming	10	13th Feb 2004 03:10 PM
Deleting rows in a workbook though all coresponding sheets	=?Utf-8?B?RGF2ZSBCYXRlcw==?=	Microsoft Excel Misc	2	8th Feb 2004 10:01 AM