D
Drew Paterson
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!
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!