Excel - How do I delete an entire document in excel 2007?

Not cells,rows,columns,sheets, the entire document, delete the entire thing.

  Gord Dibben replied to meghan

Same way you delete any file.

Close the file.

Select the file through any means you wish.

Right-click and "delete".

Answer "Yes" and off it goes to recycle bin for your disposal.


Gord Dibben  MS Excel MVP

  Don Guillett replied to meghan

You can do it with a macro using KILL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com

Is there a formlula to replace cell shade color with another color Excel Is there a Find and Replace type of formula where which will find cells with a formatted with one pattern color and replace them with a new pattern color.? Excel Worksheet Discussions Microsoft Excel (1) Excel (1) Worksheet (1) Macro (1) ExcelSalesAid (1) GuillettMicrosoft (1) SalesAid (1) Softwaredguillett (1) Need a macro - - Don Guillett Microsoft MVP Excel SalesAid Software

sort macro Excel Hello, I would like to write a macro to sort data from a list which is getting longer and longer. How to tell the macro to go to the last non empty cell? Thanks in advance, Excel Miscellaneous Discussions Excel (1) Named range (1) Worksheet (1) OFFSET (1 Macro (1) XlTopToBottom (1) ExcelSalesAid (1) GuillettMicrosoft (1) Hi, You are always better posting your code. The line below sets

Conditional formatting Excel I have a spreadsheet that contains subtotals. I would like to do conditional formatting only fill = blue If cell is greater than 35 cell fill = red I am using MS Excel Office Pro 2003. Thanks in advance for you help. Excel Miscellaneous Discussions Microsoft Excel (1) Office (1) Macro (1) VBA (1) ExcelSalesAid (1) GuillettMicrosoft (1) SalesAid (1) Coulumn (1) try formula = = right(a1), 5) = "Total" - - Don Guillett Microsoft MVP

Combine macros variable help Excel So I have recorded a number of macros that each hide a different Week. Sub Macro1() ' Macro1 Macro Application.Goto Reference: = "Week1" Selection.EntireColumn.Hidden = True End Sub . . . Sub Macro10() ' Macro10 Macro Application.Goto Reference: = "Week10" Selection.EntireColumn.Hidden = True End Sub How do I create one macro to do all of this by using a variable for the "Week number" that is to select the Week number from an input box or a drop down list? Thanks Excel Worksheet Discussions Selection.EntireColumn.Hidden (1) Excel (1) Macros (1) EntireColumn.Hidden (1) ExcelSalesAid (1) GuillettMicrosoft (1) SalesAid (1) InputBox (1) - - Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com

Delete Range of cells and move left based on Cell value Excel Hi. . I am trying to delete a range of cells in a column and move on whether or not a certain cell = 0. Any help would be great, thanks, Bill Excel Discussions AGOL.Ocean (1) Excel (1) Macro (1) ExcelSalesAid (1) GuillettMicrosoft (1) SalesAid (1) Softwaredguillett (1) Sept (1) details - - Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com Wow this might be a little hard. I