Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ensure workbook is saved before exiting Excel? | Excel Discussion (Misc queries) | |||
When opening a workbook, need to ensure user opens in a certain ce | Excel Discussion (Misc queries) | |||
Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
How to ensure function does not refer to cells outside of workbook? | Excel Programming | |||
closing excel after closing a workbook | Excel Programming |