You could perform the delete function both at the beginning and at the
end. Then, it would kill it, and then re-create it. If it isn't already
up, I do not know if that would produce an error.

On Sun, 3 Jan 2010 21:15:27 +1300, "Drew Paterson"
wrote:

I have some code in a workbook which creates a new custom toolbar when the
workbook opens and deletes it when the workbook is closed. (Excel 97)

The same process is present in earlier versions of the workbook from
previous years.

Sometimes I need to open one of those earlier versions while the current
version is already open.

This produces an error message dialog with runtime error '5'.

Hitting "End" stops the process and gets rid of it, but I would like to
insert some additional code at the start to check if the custom toolbar
already exists, and stop the code running if it does.

Basically "if (toolbar) exists then exit sub"

I have tried a variety of possibilities but no luck so far. It is probably
something simple but to date it eludes me. I'm getting a bit rusty at
coding!