| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
BeforeSave event
I am trying to build a macro that will automatically clear the contents of a
certain cell just before the workbook is saved. I tried entering is as follows but it did not work: Sub Workbook_BeforeSave() Sheets("Instructions").Select Range("E5").Select Selection.ClearContents End Sub Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Same event, multiple sheets? | Excel Discussion (Misc queries) | |||
| Excel Automation SelectionChange event | Excel Discussion (Misc queries) | |||
| Worksheet Row Change event | Excel Discussion (Misc queries) | |||
| Change of Row event | Excel Discussion (Misc queries) | |||
| Event 1001 & 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
