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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top