Look into Custom Properties of sheet
(ms help)
you can assing a custom property to the sheets you want updated ,then with
an if /then use bob's suggestion.
remember to "on error next" to overlook the sheets you have not given the cp
to


"Bob Phillips" wrote:

Presuming that you have an object variable set to the dropdown, something
like

For Each sh In Activeworkbook.Worksheets
dd.AddItem sh.Name
Next sh

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan M" wrote in message
...
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?