delete sheet

  1. M

    deleted worksheet but in VBA code, the sheet still exists in the Microsoft Excel Objects

    I have a workbook (the uses macros) with multiple sheets. We have to constantly copy a template sheet to create sheet to get the macros to copy for each sheet, but when I delete one of the sheets, and open the VBA editor, in the Microsoft Excel Objects, there is still an entry for the deleted...
  2. Carl Colijn

    Move sheet or sheet content while preserving range names

    During the last 2 weeks I've been trying to solve a seemingly unsolvable problem: how to set up a workbook with VBA, where the VBA needs to be signed, and still have users copy sheets in it, without that copying breaking the signature. There seems to be a narrow escape route, but it's still not...
  3. R

    VBA, Disable/Prevent Delete Sheet in Excel 2013/2016 without protecting workbook, Help!

    Hi All, I want to disable/prevent user to delete sheet (both through Home > Cells > Delete Sheet, or Right click on sheet > Delete), but I can't use protect workbook for this one. so VBA code is the only way, I've search anywhere but it fails because the code for excel 2007. [/IMG] [/IMG]...
  4. M

    VBA to delete sheet based on internal counter

    VBA delete sheet based on internal counter. The event must trigger each time that the user open the workbook. For example if you set up the counter to 30 the particular sheet, not the workbook, will be deleted when the user open the file 31 times. Is this info correct and the best approach...
  5. A

    Delete Sheets according to cell value

    Hi everyone, I am working on a project and I was a little confused how to do it with vba and lack of knowledge. Hope you guys can help me. I will try to explain the situation, I got an excel which has nearly 800 sheets and in sheet named "Summary" where B column has numbers from 100 to 799...
  6. Smokeyham

    Remove a worksheet, without causing a reference error?

    Working in Excel 2007, I have a spreadsheet which summarizes data from several sheets (all contained within the same file). When I delete one of the sheets, I get a reference error on the summary sheet: =#REF!A1+Sheet2!A1 Is there a way to delete a sheet, and have the reference...
  7. C

    Copy workbooks to new folder and delete some worksheets

    Hello, I need to copy all workbooks in a folder (call it C:\2009) to a new folder (C:\2010). Each workbook contains at least 1 worksheet for each month of the year so I need to delete all worksheets except the Dec 09 worksheet(s). (The worksheet names will not always be the same from workbook...
  8. melewie

    Delete Sheets if exists and create new sheet

    Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> First off I know there has been a quite a few post about this but I am really struggling with it (not sure if its because its Monday or I have the coding skills of a drunken...

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