I have a wokbook containing several named sheets and custom menu bar
containing a collection of drop-down macro items. I would like to be able to
produce a macro which will insert the sheet names into the Name property of
the custom menu items in the drop down list.

Is this possible and if so how please?