How do I add a macro to a custom menu?
 

I can't find my macros in the customize/commands list

How do I add a macro to a custom menu?
 

Where did you store them? They should be in a standard code module. If the
module has Option Private Module at the head, the macros are declared as
private, or they have arguments, you will not see them.

--

HTH

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


"MikeCyng" wrote in message
...
I can't find my macros in the customize/commands list

How do I add a macro to a custom menu?
 

Thanks for your response Bob.

They are in a module in the VB editor. I can't see 'Option Private' in the
module and there are no argumants. I can assign the macro to a button but
can't get them as items in a drop down menu.

Cheers
Mike

"Bob Phillips" wrote:

Where did you store them? They should be in a standard code module. If the
module has Option Private Module at the head, the macros are declared as
private, or they have arguments, you will not see them.

--

HTH

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


"MikeCyng" wrote in message
...
I can't find my macros in the customize/commands list

How do I add a macro to a custom menu?
 

Are you saying that you have added a dropdown tom a commandbar, and you want
to add your macros to it?

--

HTH

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


"MikeCyng" wrote in message
...
Thanks for your response Bob.

They are in a module in the VB editor. I can't see 'Option Private' in the
module and there are no argumants. I can assign the macro to a button but
can't get them as items in a drop down menu.

Cheers
Mike

"Bob Phillips" wrote:

Where did you store them? They should be in a standard code module. If
the
module has Option Private Module at the head, the macros are declared as
private, or they have arguments, you will not see them.

--

HTH

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


"MikeCyng" wrote in message
...
I can't find my macros in the customize/commands list

How do I add a macro to a custom menu?
 

Yes, I've added a 'New Menu' to the toolbar and I want to add macros as items
in the drop down menu.

"Bob Phillips" wrote:

Are you saying that you have added a dropdown tom a commandbar, and you want
to add your macros to it?

--

HTH

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


"MikeCyng" wrote in message
...
Thanks for your response Bob.

They are in a module in the VB editor. I can't see 'Option Private' in the
module and there are no argumants. I can assign the macro to a button but
can't get them as items in a drop down menu.

Cheers
Mike

"Bob Phillips" wrote:

Where did you store them? They should be in a standard code module. If
the
module has Option Private Module at the head, the macros are declared as
private, or they have arguments, you will not see them.

--

HTH

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


"MikeCyng" wrote in message
...
I can't find my macros in the customize/commands list

How do I add a macro to a custom menu?
 

I've finally managed to find a website which answers my question -
http://www.aicpa.org/pubs/jofa/jul2001/lenning.htm
I can see were i was going wrong now!

Thanks for taking the trouble to reply.

Cheers
Mike

"Bob Phillips" wrote:

Are you saying that you have added a dropdown tom a commandbar, and you want
to add your macros to it?

--

HTH

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


"MikeCyng" wrote in message
...
Thanks for your response Bob.

They are in a module in the VB editor. I can't see 'Option Private' in the
module and there are no argumants. I can assign the macro to a button but
can't get them as items in a drop down menu.

Cheers
Mike

"Bob Phillips" wrote:

Where did you store them? They should be in a standard code module. If
the
module has Option Private Module at the head, the macros are declared as
private, or they have arguments, you will not see them.

--

HTH

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


"MikeCyng" wrote in message
...
I can't find my macros in the customize/commands list

How do I add a macro to a custom menu?
 

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

MikeCyng wrote:

I can't find my macros in the customize/commands list

--

Dave Peterson