Forcing the Custom Menu to be displayed in the worksheet on Startu

[GLT]

Hi,

Doeas anyone know how to make the Custom Menu dialog boxbe part of the
worksheet, so when it opens people can easily locate it?

Currently the people using my sheet are advising that when Excel opens the
Custom Menu dialog box does not get displayed....

[Jake Marx]

Hi GLT,

GLT wrote:
> Doeas anyone know how to make the Custom Menu dialog boxbe part of the
> worksheet, so when it opens people can easily locate it?
>
> Currently the people using my sheet are advising that when Excel
> opens the Custom Menu dialog box does not get displayed....

I'm not sure what you're looking for exactly, but maybe this will help?

Application.CommandBars.FindControl(Id:=797).Execute

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]