Renaming an exisiting toolbar

[Excel2006]

Hi

How do you rename an exisiting toolbar using a macro?

Rename exisiting toolbar "Test" to "Report"


Set mybar = Application.CommandBars("test")

 

[venkat1926]

rightlcick any toolbar and click customize.
in the customize window highlight the relevant toolbar(test) and click rename on the right side. type the new name and click ok and close the window.

if you want a vba code

use this code statement

    Application.CommandBars("test").Name = "report"

 

[Excel2006]

Thx for your help.