delete worksheet

  1. P

    Deleting a worksheet based on a drop down list value

    I have a spreadsheet set up with thousands of worksheets, however I do not need them all depending on the value of a drop down list. Any ideas how I can do this?
  2. L

    Delete Worksheet if 'text' is found within it

    Hi, I would like a macro to delete my worksheet called 'Scorecard' if the word 'abandoned' is found within it. The current macro imports web data but if it imports one with the word 'abandoned' on it I would like the whole worksheet (Scorecard) to be deleted. Let me know if you need anymore...
  3. M

    Copy and Rename worksheet in Shared workbook

    I have created a "Time Clock" spreadsheet that is shared with other hourly employees in my office. I have some vba code which will copy a "template" worksheet and rename it according to the employee using the workbook. It works fine until I set the workbook to be a SHARED workbook. How can I...
  4. MarkCBB

    Delect all Worksheets that begind with Sheet

    Hi There, This is a strange request for some code. I need some code that is Triggered "On Open" of the workbook, that deletes all the worksheets of that workbook that begin with Sheet. I.e. if I have 3 Sheets And I name one MASTER, and the other 2 are called Sheet1 and Sheet2, they must be...
  5. S

    can't delete a worksheet in another worksheet

    Hi guys, help me with this cause i'm totally freaking out the error is probably very stupid but i can't find it i spent two hours looking everywhere i simply wrote a macro that deletes (hopefully) a sheet in another workbook here's the code: Sub aaa() Dim excelApp As Excel.Application Dim...
  6. M

    Delete Empty Worksheets

    Hello, I would like to create a macro that searches a workbook to determine how many worksheets contain data. It will delete the empty worksheets and record in an array, the position of the active worksheets. So far I'm getting stuck on the delete function "A workbook must contain at least...
  7. N

    Deleting worksheets

    I am deleting a protected worksheet by first unprotceting it and then using the worksheets("nam").delete method.The Worksheet gets deleted but as soon as it completes executing the line for deleting the sheet(i.e. worksheets("nam").delete ) it shows a message "Cannot enter break mode at...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top