Custome menu question

[Guest]

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?

 

[Bob Phillips]

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)

 

[Guest]

Hi Bob..

not all worksheets in the book need this treatment.


Here is the situation

I have 6 sheets all named after current stock lines. If those line names
change I want to alter the name of the drop down macro to match the sheet
name of the new ones.

There are other sheets in the work book,

How do I set the object to the dd name please.

 

[Guest]

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