| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I branch from to
Private Sub CommandButton1_Click()
From here... End Sub TO Private Sub Workbook_BeforeClose(Cancel As Boolean) code here... Application.Quit End Sub Thank's Ahead. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I branch from to
On Saturday, November 10, 2012 7:46:26 AM UTC-5, Bobby wrote:
Private Sub CommandButton1_Click() From here... End Sub Sorry I found my answer. Thisworkbook.close TO Private Sub Workbook_BeforeClose(Cancel As Boolean) code here... Application.Quit End Sub Thank's Ahead. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I branch from to
hi
Private Sub CommandButton1_Click() ThisWorkbook.Close End Sub -- isabelle Le 2012-11-10 07:46, Bobby a écrit : Private Sub CommandButton1_Click() From here... End Sub TO Private Sub Workbook_BeforeClose(Cancel As Boolean) code here... Application.Quit End Sub Thank's Ahead. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I branch from to
On Saturday, November 10, 2012 7:46:26 AM UTC-5, Bobby wrote:
Private Sub CommandButton1_Click() From here... End Sub TO Private Sub Workbook_BeforeClose(Cancel As Boolean) code here... Application.Quit End Sub Thank's Ahead. Hi Isabelle, could you be more explicit as per the how to branch I.E: goto Workbook_BeforeClose for example |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I branch from to
hi,
if you run the command ThisWorkbook.Close Workbook_BeforeClose event will automatically execute -- isabelle Le 2012-11-10 12:24, Bobby a écrit : Hi Isabelle, could you be more explicit as per the how to branch I.E: goto Workbook_BeforeClose for example |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I branch from to
On Saturday, November 10, 2012 3:09:55 PM UTC-5, isabelle wrote:
hi, if you run the command ThisWorkbook.Close Workbook_BeforeClose event will automatically execute -- isabelle Le 2012-11-10 12:24, Bobby a �crit : Hi Isabelle, could you be more explicit as per the how to branch I.E: goto Workbook_BeforeClose for example Hi Isabelle! Thank you for your advice! Work's well. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I branch from to
On Saturday, November 10, 2012 7:46:26 AM UTC-5, Bobby wrote:
Private Sub CommandButton1_Click() From here... End Sub TO Private Sub Workbook_BeforeClose(Cancel As Boolean) code here... Application.Quit End Sub Thank's Ahead. Hi Isabelle I did try your suggestion but unfortunately it does not branch to my Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayAlerts = False Application.Quit End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write a branch to another macro | Excel Worksheet Functions | |||
| how do i create chart like branch-sector sales & collections | Excel Discussion (Misc queries) | |||
| How can I contact branch Office in Tokyo, Japan? | New Users to Excel | |||
| How to branch? | Excel Programming | |||
| Establish a Branch of Clayton College here in Malaysia | Excel Worksheet Functions | |||
![Bobby[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
