Menu attached to a form?
 

Hi,
I'm converting a rather complex Excel-workbook into an Excel-application and
I'm hiding the main-window and only displaying forms with different views of
data from the underlying document.
I would like my "main form" to appear as an application window with a
main-menu attached to it. How do I accomplish this?

Thanks in advance!
StefanW

Menu attached to a form?
 

You can't attach a menu to a VBA form, unlike VB.

--

HTH

RP

"StefanW" wrote in message
...
Hi,
I'm converting a rather complex Excel-workbook into an Excel-application
and
I'm hiding the main-window and only displaying forms with different views
of
data from the underlying document.
I would like my "main form" to appear as an application window with a
main-menu attached to it. How do I accomplish this?

Thanks in advance!
StefanW

Menu attached to a form?
 

Thank you Bob!
Now I can stop browsing the help-files!

Best regards,
StefanW

"Bob Phillips" wrote:

You can't attach a menu to a VBA form, unlike VB.

--

HTH

RP

"StefanW" wrote in message
...
Hi,
I'm converting a rather complex Excel-workbook into an Excel-application
and
I'm hiding the main-window and only displaying forms with different views
of
data from the underlying document.
I would like my "main form" to appear as an application window with a
main-menu attached to it. How do I accomplish this?

Thanks in advance!
StefanW

Menu attached to a form?
 

Hi Stefan,
Could be that this example can be useful for you:
http://www.excelabo.net/moteurs/comp...usdansuserform

Regards,
MP

"StefanW" a écrit dans le message de
...
Hi,
I'm converting a rather complex Excel-workbook into an Excel-application
and
I'm hiding the main-window and only displaying forms with different views
of
data from the underlying document.
I would like my "main form" to appear as an application window with a
main-menu attached to it. How do I accomplish this?

Thanks in advance!
StefanW