J
John T Ingato
Although the VBA reference states that the commandbars.width property is a
get/set property I am getting errors everytime I try to adjust the size of a
custom command bar.
I have created a bar called "Zipbar" in an addin and in a function I am
trying to set the width with:
commandbars(Zipbar").width = 120
With that line of code I get an automation error:
RunTime error '-2147467259(80004005)
Method 'Width' of object 'Commandbar' failed
'Help" offers no advice. Just "automation error 440"
cbWidth = commandbars("Zipbar"). width will yield a value so I know it is
installed properly and part of the collection
Can someone tell me what I am doing wrong.
My ultimate goal here was to acquaint myself with the exzcting placiment of
docked control bars and have learned that control bars widths are measured
in pixels, but the usablewidth of the application is measured in points. A
little weird huh?
get/set property I am getting errors everytime I try to adjust the size of a
custom command bar.
I have created a bar called "Zipbar" in an addin and in a function I am
trying to set the width with:
commandbars(Zipbar").width = 120
With that line of code I get an automation error:
RunTime error '-2147467259(80004005)
Method 'Width' of object 'Commandbar' failed
'Help" offers no advice. Just "automation error 440"
cbWidth = commandbars("Zipbar"). width will yield a value so I know it is
installed properly and part of the collection
Can someone tell me what I am doing wrong.
My ultimate goal here was to acquaint myself with the exzcting placiment of
docked control bars and have learned that control bars widths are measured
in pixels, but the usablewidth of the application is measured in points. A
little weird huh?