On Tue, 2 Aug 2005, Bob Phillips wrote:

Have you just tried closing it from VBA?

workbooks("ProcDB.xla").close

Hey. That works! But one had better remove the menu entry first.

While playing with this I think I found a better way to solve my problem.
Previously I had just been making the toolbar not visible, and as I noted I
would have periodic problems with my row numbers disappearing. What I do
now is to Delete the toolbar. So far so good.

For those following this thread here is how I was/am getting rid of the
toolbar:

On Error Resume Next
Application.CommandBars("xxxx").Visible = False
Application.CommandBars("xxxx").Delete

And to remove the menu entry before closing the addin you use:

Application.CommandBars("Worksheet Menu Bar").Controls("xxxx").Delete

Don <www.donwiss.com (e-mail link at home page bottom).