Ok this my be hard to discribe but here goes.

I would like to create a customised menu toolbar with a menu drop down list.
I would like a menu under this drop down list to show a 6 digit number as
it's name. When the user clicks on this number a macro is run that asks the
user for a new 6 digit number and displays this as the new menu name. I would
like this new 6 digit name to be store in a public variable for other macros
to use.

I would like this menu button in a toolbar menu not in a excel file cell
drop down list.

Is this possible?

Thanks