Hide the main menu bar temporarily

[Guest]

In Office 2003, I'm coding a Report so that when the report is displayed, a
custom toolbar appears and then is deleted when the report is closed. This
part runs perfectly.

However, I need the main "Menu Bar" to become hidden when the user clicks
the Report button so the user only sees the choices on my custom toolbar. How
can I temporarily hide the menu bar?

I tried: Application.Commandbars("Menu Bar").Visible = False
But this does not work...

Thanks.

 

[Alex Dybenko]

I think you can make a custom menu bar for reports, and set menu bar
property to name of this menu bar - then it will replace default one when
report opens

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Hi Alex,

I couldn't get this to work; it seems to be wanting a macro name? - I put in
the name of my toolbar but this fails...can you guide me as to what I am
missing?

Thanks...

 

[Alex Dybenko]

just make a new command bar (like you did with toolbar), set its type to
menu bar and then you can use it in this property

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com