| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook before close
I want to delete two sheets before the file is closed everytime.
I had writen some similar code before, but I can't remember it and this time it doesn't work. I must have something wrong here. Private Sub WorkbookBeforeClose(ByVal Wb As Workbook, _ Cancel As Boolean) Sheets("Summary").Select Sheets("Sheet2").Select End Sub By the way, when before the sheets are deleted it always asks you to confirm. Is it possible to put in a line to make the confirmation automatical? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide all Sheets in Workbook then Close Workbook | Excel Programming | |||
| Open New Workbook / Save and Close Current Workbook | Excel Programming | |||
| Closing a workbook from a macro doesn't close the workbook | Excel Programming | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
| Close a the current workbook and load another specified workbook | Excel Programming | |||
Threaded Mode
