Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to save workbook within WorkbookBeforeClose
Hi, I'm trying to save the current workbook within the WorkbookBeforeClose but the file is not saving. The WorkbookBeforeClose is an application level event in my com addi with the following signatur Private Sub mExcel_WorkbookBeforeClose(ByVal Wb As Excel.Workbook Cancel As Boolean) If Not Wb.saved Then Wb.Save Wb.saved =True End If End Sub Calling the Wb.Save should save the workbook, but it didn't. Am I doing something wrong here ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to save workbook within WorkbookBeforeClose
Application.ScreenUpdating = Fals
Application.DisplayAlerts = Fals ActiveWorkbook.Sav Application.DisplayAlerts = True |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to save workbook within WorkbookBeforeClose
.... an be sure your macros are enabled!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UNABLE TO SAVE FORMATTING | Excel Worksheet Functions | |||
Unable to save XLSX files without using 'Save As' and different na | Setting up and Configuration of Excel | |||
Unable to save | New Users to Excel | |||
unable to save current workbook within WorkbookBeforeClose | Excel Programming | |||
Handling WorkbookBeforeClose and WorkbookBeforeSave | Excel Programming |