Worksheet Menu Toolbar
 

Hi all,

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

Thanks All.


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=544657

Worksheet Menu Toolbar
 

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

Worksheet Menu Toolbar
 

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

--
Regards,
Tom Ogilvy


"gti_jobert" wrote:


Hi all,

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

Thanks All.


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=544657

Worksheet Menu Toolbar
 

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

Thanks Again!

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=54465

Worksheet Menu Toolbar
 

Got it, no worries....cheers!


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=544657