reset menu and toolbar usage data

[Aleksandr]

Is it possible to call standard MS Office function "reset menu and toolbar
usage data" (Tools->Customize->Options) from VB code? I need to reset usage
statistics in some cases.

 

[Alex Dybenko]

Hi,
try like this:

commandbars("Main Menu").Reset

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Aleksandr]

Run-time error '-2147467259 (80004005)':
Method 'Reset' of object 'CommandBar' failed

 

[Alex Dybenko]

Will it work, if you manually reset same commandbar?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Aleksandr]

What do you mean "manually" ?
Is it possible to reset the data of only one toolbar?

If i press "reset menu and toolbar usage data" button from the menu, it
works just fine. Exactly what i need.

 

[Alex Dybenko]

if you go to tools-customize, select any toolbar (menubar) there and click
reset - then you will reset this toolbar

code I posted - do the same

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Aleksandr]

In my case (i don't know why), this toolbar can not be reseted - the
"Reset..." button is disabled. :/
Maybe you know the reason or the solution ? I would be very grateful..

 

[Aleksandr]

BTW, the toolbar I want to reset is not standard one

 

[Alex Dybenko]

I think this explains - if this is a custom toolbar - then reset has no
sense - right?

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Aleksandr]

Yes, that's right. You can not reset the custom toolbar.
I have just found the solution - i needed to have some buttons on the
toolbar at specified place - so i just added PRIORITY property to the button
and selected higher value to it.

Thank you very much, Alex, for participating

Spasibo