Thread: commandbar hunt
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DEFJ DEFJ is offline
external usenet poster
 
Posts: 13
Default commandbar hunt

is there a way to check and see if a custom commandbar
exists? I have a commandbar that is created at runtime.
The problem is when you open 2 versions of the workbook,
it errors out because a commandbar already exists with the
same name (makes sense). I tried just adding a delete
commandbar on the open event (then rebuilding the
commandbar), the problem here is if it's the first time
you've opened the sheet...can't find the commandbar I want
it to delete (also makes sense). Because it's custom,
searching by ID doesn't seem to work...ARRGGGGHHH

thnks in advance