| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed with this autosave macro problem
Hi,
My whole intention is to close the active workbook without beeing prompth by Windows "do you wanna save the changes....". But unfortunately when I use the below code I am getting a Compile error with the msgbox "Procedure declaration does not match description or event procedure having the same name". Hope someone can help me to correct this. -------- Private Sub Workbook_BeforeClose() ActiveWorkbook.Save End Sub -------- Regards J_J |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help needed with this autosave macro problem
try
Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub Patrick Molloy Microsoft Excel MVP "J_J" wrote: Hi, My whole intention is to close the active workbook without beeing prompth by Windows "do you wanna save the changes....". But unfortunately when I use the below code I am getting a Compile error with the msgbox "Procedure declaration does not match description or event procedure having the same name". Hope someone can help me to correct this. -------- Private Sub Workbook_BeforeClose() ActiveWorkbook.Save End Sub -------- Regards J_J |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help needed with this autosave macro problem
Ahaa!....
So the trick was to have "cancel as boolean" Thanks Patrick. That did it!. J_J "Patrick Molloy" wrote in message ... try Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub Patrick Molloy Microsoft Excel MVP "J_J" wrote: Hi, My whole intention is to close the active workbook without beeing prompth by Windows "do you wanna save the changes....". But unfortunately when I use the below code I am getting a Compile error with the msgbox "Procedure declaration does not match description or event procedure having the same name". Hope someone can help me to correct this. -------- Private Sub Workbook_BeforeClose() ActiveWorkbook.Save End Sub -------- Regards J_J |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help needed with this autosave macro problem
Sometimes, it's better to be lazy.
If you used those dropdowns at the top of the code window in the VBE, then you'll get the correct name/syntax for those builtin events. J_J wrote: Ahaa!.... So the trick was to have "cancel as boolean" Thanks Patrick. That did it!. J_J "Patrick Molloy" wrote in message ... try Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub Patrick Molloy Microsoft Excel MVP "J_J" wrote: Hi, My whole intention is to close the active workbook without beeing prompth by Windows "do you wanna save the changes....". But unfortunately when I use the below code I am getting a Compile error with the msgbox "Procedure declaration does not match description or event procedure having the same name". Hope someone can help me to correct this. -------- Private Sub Workbook_BeforeClose() ActiveWorkbook.Save End Sub -------- Regards J_J -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoSave Macro? | Excel Discussion (Misc queries) | |||
| autosave macro excel | Excel Discussion (Misc queries) | |||
| Problem with Autosave | Excel Discussion (Misc queries) | |||
| Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
| AutoSave code problem | Excel Programming | |||
Hybrid Mode
