How to ensure a VBA sub is run before closing a workbook
What syntax would I use to make sure specific subs are run before Excel
closes the active workbook. These subs are error checks and I need VBA to vet the data and alert the user there are errors before the workbook is closed. Is it the Workbook_Before Close event?. I tried adding the syntax below but it didn't trigger the subs. Also would an On Save type event (if there is one) be a better alternative. Can anyone recommend a solution with some code please. Many thanks Jacqui Private Sub Workbook_BeforeClose() Qualifiers_Check Disable_Check End Sub |
How to ensure a VBA sub is run before closing a workbook
The event is correct. Did you put the code in the ThisWorkbook code module.
-- HTH RP (remove nothere from the email address if mailing direct) "Jacqui" wrote in message ... What syntax would I use to make sure specific subs are run before Excel closes the active workbook. These subs are error checks and I need VBA to vet the data and alert the user there are errors before the workbook is closed. Is it the Workbook_Before Close event?. I tried adding the syntax below but it didn't trigger the subs. Also would an On Save type event (if there is one) be a better alternative. Can anyone recommend a solution with some code please. Many thanks Jacqui Private Sub Workbook_BeforeClose() Qualifiers_Check Disable_Check End Sub |
How to ensure a VBA sub is run before closing a workbook
BTW, syntax of BeforeClose is
Private Sub Workbook_BeforeClose(Cancel As Boolean) End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Jacqui" wrote in message ... What syntax would I use to make sure specific subs are run before Excel closes the active workbook. These subs are error checks and I need VBA to vet the data and alert the user there are errors before the workbook is closed. Is it the Workbook_Before Close event?. I tried adding the syntax below but it didn't trigger the subs. Also would an On Save type event (if there is one) be a better alternative. Can anyone recommend a solution with some code please. Many thanks Jacqui Private Sub Workbook_BeforeClose() Qualifiers_Check Disable_Check End Sub |
How to ensure a VBA sub is run before closing a workbook
The BeforeClose procedure declaration is incorrect. The best way to
get these relatively trivial things correct is to let XL do the work. The code goes in the Workbook's code module. The easiest way to figure out where is to right-click the workbook icon to the left of the 'File' in the menu bar and select View Code. In the XL VBE towards the middle top there is a drop down that will read (General). Use it to select Workbook. In the adjacent dropdown, select BeforeClose. You will now have the correct syntax for the BeforeClose procedure. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... What syntax would I use to make sure specific subs are run before Excel closes the active workbook. These subs are error checks and I need VBA to vet the data and alert the user there are errors before the workbook is closed. Is it the Workbook_Before Close event?. I tried adding the syntax below but it didn't trigger the subs. Also would an On Save type event (if there is one) be a better alternative. Can anyone recommend a solution with some code please. Many thanks Jacqui Private Sub Workbook_BeforeClose() Qualifiers_Check Disable_Check End Sub |
All times are GMT +1. The time now is 03:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com