View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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