Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open & close event
not having done this befor. use open event to start then in same workbook
code window can you put an close event sub. thinking that close will run on all worksheets in workbook when closed? posed the question as am not good at this. am expermitting only looking to find if I am going right way. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open & close event
Curt,
Is this what you mean ? Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets With WS 'do something End With Next End Sub NickHK "Curt" wrote in message ... not having done this befor. use open event to start then in same workbook code window can you put an close event sub. thinking that close will run on all worksheets in workbook when closed? posed the question as am not good at this. am expermitting only looking to find if I am going right way. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
open & close event
Thank You
"NickHK" wrote: Curt, Is this what you mean ? Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets With WS 'do something End With Next End Sub NickHK "Curt" wrote in message ... not having done this befor. use open event to start then in same workbook code window can you put an close event sub. thinking that close will run on all worksheets in workbook when closed? posed the question as am not good at this. am expermitting only looking to find if I am going right way. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't save before close event? | Excel Programming | |||
Open/Close Event and Excel Saving process | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
After Close Event? | Excel Programming |