ExcelBanter - Deleting sheets within a workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Deleting sheets within a workbook (https://www.excelbanter.com/excel-programming/420805-deleting-sheets-within-workbook.html)

CAM

Deleting sheets within a workbook

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

JLGWhiz

Deleting sheets within a workbook

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

All times are GMT +1. The time now is 02:09 AM.