Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does a toolbar already exist?
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! -- Drew Paterson Paraparaumu New Zealand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide custom toolbar from Toolbar list | Excel Programming | |||
Form Toolbar verses Control Toolbar | Excel Discussion (Misc queries) | |||
Add-In Toolbar Control - Removing The Toolbar Question | Excel Programming | |||
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist | Excel Programming | |||
Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it. | Excel Programming |