| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I clear cell content when excel document is closed?
I am trying to clear the content of some "data" cells when I close the excel
document, without having to go to "edit,clear,content" route. Is this possible? |
|
#2
|
|||
|
|||
|
Hold and click Ctrl+F11 to open the VB editor. In the 'Project - VBA Project
window" find and double click on "ThisWorkbook". Then paste this code... (Change range to suite) Private Sub Workbook_Close() Range("E6:G15").Select Selection.ClearContents End Sub "m3155" wrote: I am trying to clear the content of some "data" cells when I close the excel document, without having to go to "edit,clear,content" route. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I imbed a Word document into an Excel cell? | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
| Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
Linear Mode
