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
|