| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE AN EXCEL WORKBOOK
Here is one I have assigned to a custom toolbar button
Sub KillActiveWorkbook() With ActiveWorkbook mb = .Name .Close End With MyAnswer = MsgBox("Do you want to KILL this file?", vbYesNo) If MyAnswer = vbYes Then Kill mb End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "dmhehir" wrote in message ... How does one Delete an Entire Workbook as opposed to a Worksheet -- Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete Blank lines in excel workbook? | Excel Discussion (Misc queries) | |||
| Excel names in workbook - how to delete all? | Excel Discussion (Misc queries) | |||
| I can't delete an image in excel workbook | Excel Discussion (Misc queries) | |||
| how to delete an old workbook from the right column in excel | Excel Discussion (Misc queries) | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Hybrid Mode
