worksheet delete

  1. R

    Deleting mutliple worksheets from a workbook if they conatin a specific tab name.

    HI, I have created the below macro to do this but it does not run through the whole workbook, I keep having to re-run the macro to delete other sheets (Some workbooks conatin 6-7 worksheets that end in Cube or Chart) Also If I could get it to stop asking me before deleting the worksheets and...
  2. L

    Excel 2003: Add worksheet with variable as worksheet name?

    OK, folks... some more VBA help needed please!!! I need to create a macro which will prompt the user to select a PDF file on their HDD, then have the PDF filename used as the worksheet name. The PDFs have the same naming convention: "MachineReport 1234ABC 31102011" where MachineReport is...
  3. E

    Delete Sheet Event

    Is there a way of detecting the deletion of a worksheet. I have a workbook that includes a drop down list of the current worksheets. So if a worksheet is deleted, I need to update this list. Is there a way of trapping this event? Thanks Steve

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top