delete worksheets

  1. M

    Excel VBA: Delete and Merge Sheets

    Hi, I am a beginner in Excel VBA. When I download an Excel report from my accounting system, it generates 2 extra empty sheets called "Sheet2" and "Sheet3". I only need "Sheet1". This repeats for all other 10 reports that I download from the system. What I need to do is to delete "Sheet2" and...
    • MLCR
    • Thread
    • delete worksheets merging workbooks vba
    • Replies: 8
    • Forum: Excel Questions
  2. M

    Delete all tabs except one

    Hi Everyone, Just looking for some code to help me delete tabs after a workbook split. Basically, I have a macro that splits a worksheets (not workbooks) by a unique identifier found in column A. I would like all tabs except the relevant one to be deleted from the new file, and there are too...
    • m5edward
    • Thread
    • delete worksheets excel & macro macro split workbook vba & excel
    • Replies: 1
    • Forum: Excel Questions
  3. J

    Trouble with Disappearing UserForms when Running VBA Code to Delete Unneeded Worksheets

    Hello. This is my first post so thanks for your patience. Prior to posting this thread I have exhausted many hours on multiple forum websites, Excel VBA books and other help resources. I'm spent. COMPUTER/SOFTWARE: I'm working on a US Military PC (Windows 7 Enterprise, Service Pack 1 // MS...
    • JasonLiska
    • Thread
    • code disappears code stops quits delete worksheets modeless userform userform
    • Replies: 8
    • Forum: Excel Questions
  4. T

    Enable "Delete Worksheet" in macro-enabled workbook

    I have a macro-enabled workbook with a lot of worksheets. I am trying to delete/replace a worksheet but "Delete Sheet" is grayed out in both the "Edit" menu and RtMouseClick menu. "Insert Sheet" is also grayed out. The sheet is not protected and the workbook is not shared. Can someone please...
  5. O

    Can a formula be made to delete worksheets

    I am working on an Excel workbook and I was wondering if a formula can be written that, if "X" was entered in a specific cell, selected worksheets from that workbook would be deleted. We are trying to create templates for a specific product; that product can be installed with various sign...

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
Back
Top