delete sheet

Hello. I have a worksheet with my raw data on. I successfully created two PIVOT tables on new worksheets. I then deleted the worksheets with the PIVOT tables on because I wanted to start afresh. Excel won;t let me insert a new PIVOT table now. I get the error message "The PIVOTTable field name...

Hello, I have a excel that has few boxes with drop down options. The first option is an empty cell (Choice = 1) I would like my code to check if there is already something chosen inside that cell and find the name that the previous user had given it (in this example the user had named it...

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

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

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

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

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

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

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

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