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

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....

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

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).Execu te

--
Regards,

Jake Marx
www.longhead.com


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