Does anyone know how to program in VB the following

If "This workbook is closed" then
do something

Any ideas are appreciated. Thanks.

This might work for you.

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
your code
End Sub

Steve


wrote in message
oups.com...
Does anyone know how to program in VB the following

If "This workbook is closed" then
do something

Any ideas are appreciated. Thanks.

I should have been more specific. I have a macro that does some things
including open up a workbook, then I need the macro to wait until this
workbook is closed while I edit some values, then proceed with the rest
of the values.

Any ideas?

I can't give specifics, but I do know you can program macro to bring up
dialog box that calls for entering data. Macro halts further action
until data is entered in dialog box. Perhaps you could set it up so
that the values to be entered are entered into such a dialog box.

WindsurferLA

wrote:
I should have been more specific. I have a macro that does some things
including open up a workbook, then I need the macro to wait until this
workbook is closed while I edit some values, then proceed with the rest
of the values.

Any ideas?

There is no wait capability in a macro that supports this.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I should have been more specific. I have a macro that does some things
including open up a workbook, then I need the macro to wait until this
workbook is closed while I edit some values, then proceed with the rest
of the values.

Any ideas?