Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a Workbook
Hi! If I have a drawn button and assign a macro that looks like this: [Begin Code] Sub ExitWarrantybook() Application.ScreenUpdating = False ActiveWorkbook.Save Sheets("Home Page").Select Range("H26").Select Selection.ClearContents ActiveWorkbook.Close ActiveWorkbook.Saved = True Application.ScreenUpdating = True End Sub [end Code] And I have code in the "ThisWorkbook" section that looks like this: [begin code] Sub Workbook_BeforeClose(Cancel As Boolean) Application.ScreenUpdating = False ActiveWorkbook.Save ActiveWorkbook.Saved = True With ActiveWindow ..DisplayHeadings = True ..DisplayOutline = True ..DisplayWorkbookTabs = True End With Application.ScreenUpdating = True End Sub [end code] Do both sets of code run before the workbook closes? -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=500427 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a Workbook
I think your problem is not that they are not running, but that you save the workbook before selecting the "Home Page" and all that. Try moving the ActiveWorkbook.Save line to after those modification lines. (also it may be safer to use ThisWorkbook instead of ActiveWorkbook, it's not quite clear what you are trying to do). Szalapski -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=500427 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
Help with closing down a workbook?? | Excel Worksheet Functions | |||
closing excel after closing a workbook | Excel Programming | |||
Closing a workbook | Excel Programming | |||
closing workbook | Excel Programming |