Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default DELETE AN EXCEL WORKBOOK

How does one Delete an Entire Workbook as opposed to a Worksheet
--
Don
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 293
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete Blank lines in excel workbook? Hemant Excel Discussion (Misc queries) 2 September 20th 09 01:37 PM
Excel names in workbook - how to delete all? GOH Excel Discussion (Misc queries) 4 May 21st 08 05:30 AM
I can't delete an image in excel workbook [email protected] Excel Discussion (Misc queries) 6 October 13th 06 06:41 PM
how to delete an old workbook from the right column in excel R.P. Excel Discussion (Misc queries) 1 September 25th 06 04:05 AM
How to Delete a Range in Closed Workbook (to Replace Delete Query) [email protected] Excel Discussion (Misc queries) 1 March 8th 06 10:10 AM


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"