But your code was in the BeforeClose event, not BeforeSave.Why would you not
want the toolbar deleted when closing the workbook just because the user
chose not to save it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"daithimcc " wrote in message
...
Thanks for the posts. Using the method you suggest, the toolbar is
deleted even if the user chooses Cancel when prompted to Save. The
workbook must only delete the toolbar if Cancel has not been pressed in
the Save dialog.
(This is why I was trying to use a variable itsclsing).
Any further suggestions would be appreciated.
Thanks, David


---
Message posted from http://www.ExcelForum.com/