Custome menu question
 

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?

Custome menu question
 

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?

Custome menu question
 

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.




"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?

Custome menu question
 

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?