Worksheet Menu Toolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gti_jobert - 23 May 2006 13:12 GMT

Hi all,

Is it possible to remove the Worksheet Menu Bar from the
excel.application?

Thanks All.

Signature

gti_jobert

Reply to this Message

Jan Karel Pieterse - 23 May 2006 13:24 GMT

Hi Gti_jobert,

> Is it possible to remove the Worksheet Menu Bar from the
> excel.application?

Application.Commandbars("Worksheet Menu Bar").Enabled=False

Be VERY sure you set that back to true before your app quits! Otherwise
you'll p^$% -off many users.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Reply to this Message

Tom Ogilvy - 23 May 2006 13:28 GMT

application.CommandBars("Worksheet Menu Bar").Enabled = False

Signature

Regards,
Tom Ogilvy

> Hi all,
>
> Is it possible to remove the Worksheet Menu Bar from the
> excel.application?
>
> Thanks All.

Reply to this Message

gti_jobert - 23 May 2006 14:33 GMT

Thanks Guys......what about the forumla bar at the top, I was tryin
ActiveWindow.DisplayFormula but found out this is wrong!

Thanks Again!

Reply to this Message

gti_jobert - 23 May 2006 14:45 GMT

Got it, no worries....cheers!

Signature

gti_jobert

Reply to this Message