Command Bar with Number in Name
Matt,
Not what you want to hear, but it loaded fine for (XL2000, XP Pro).
Do you get an error, or just no toolbar (you do make it visible don't
you?).?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Matt Jensen" wrote in message
...
My app is (unfortunately (for cell reference reasons)) named the A10
Checklist. I've created a menu bar for it which loads fine etc., unless I
try to call the tool/command bar A10 Checklist. if I take out the 10 it
works fine. i.e..
Dim objA10Bar As CommandBar
Set objA10Bar = CommandBars.Add(Name:="A10 Checklist",
Position:=msoBarFloating, Temporary:=True)
the above does not work, whereas
Dim objA10Bar As CommandBar
Set objA10Bar = CommandBars.Add(Name:="A Checklist",
Position:=msoBarFloating, Temporary:=True)
works fine. How can I add a number into the toolbar name?
Thanks
Matt
|