If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DELETE AN EXCEL WORKBOOK
How does one Delete an Entire Workbook as opposed to a Worksheet
-- Don |
#2
|
|||
|
|||
DELETE AN EXCEL WORKBOOK
Hi Don,
You could select the file using: .. File|Open from within Excel; or .. Windows Explorer, and press the delete button ... -- Cheers macropod [Microsoft MVP - Word] "dmhehir" wrote in message ... How does one Delete an Entire Workbook as opposed to a Worksheet -- Don |
#3
|
|||
|
|||
DELETE AN EXCEL WORKBOOK
hi
close the workbook. then in the file open dialog, select the file and hit the delete key. you will be asked to confirm. click yes. file gone to recycle bin. regards FSt1 "dmhehir" wrote: How does one Delete an Entire Workbook as opposed to a Worksheet -- Don |
#4
|
|||
|
|||
DELETE AN EXCEL WORKBOOK
Thanks - Worked like a charm
-- Don "FSt1" wrote: hi close the workbook. then in the file open dialog, select the file and hit the delete key. you will be asked to confirm. click yes. file gone to recycle bin. regards FSt1 "dmhehir" wrote: How does one Delete an Entire Workbook as opposed to a Worksheet -- Don |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|