Tool bars and menus
 

HI is there a some VBA code the will hide the tope tool bars and mak
what ever sheet is active to full screen (Similar to a powerpoin
presnetation)

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=37558

Tool bars and menus
 

For Each oCB in Application.Commandbars
If oCB.Visible Then
oCB.Visible = False
End If
Next oCB

Application.Commandbars(1).Enabled = False

You will need to rest at the end.

--
HTH

Bob Phillips

"funkymonkUK"
wrote in message
...

HI is there a some VBA code the will hide the tope tool bars and make
what ever sheet is active to full screen (Similar to a powerpoint
presnetation).


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=375588