delete worksheet

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?

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

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

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

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

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

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