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

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

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