"Don Wiss" wrote in message
...
On 17 Jan 2005, Bob Phillips wrote:

Don Wiss wrote:
Can I detect when a user selects cancel in a BeforeClose event? It
appears
to me that the event has already been run when the user is asked if
they
want to save, not save, or cancel. I don't see an AfterCancel event.

This as the BeforeClose is removing my Toolbar and I'd like to put it
back
after a cancel.

How about removing the toolbar in Workbook_Deactivate, and restore it in
Workbook_Activate as well as workbook_Open?

If in a Workbook_Activate it wouldn't need to be in a Workbook_Open. I am
using this way now. The only downside is when flipping between workbooks
that use the toolbar the toolbar disappears and then reappears. I haven't
yet found a way around this.


If you knew all the workbooks that use the toolbar, you could use
Application events, initiated from Personal.xls.