Link to home
Start Free TrialLog in
Avatar of MirageSF
MirageSF

asked on

Get rid of EXCEL title BAR

Hi,

I know how to open Excel up to fullscreen as much as possible, but obviously still have the very top Windows bar for EXCEL with the MIN/MAX X etc, does anyone have a way of removing that also so the sheet totally consumes the screen?

Cheers
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

To enter fullscreen
  1. Click Ribbon Display Option in title-bar
  2. Select Auto-Hide Ribbon

To exit fullscreen
  1. Click ellipses in title-bar
  2. Select one of the other two display options

https://www.youtube.com/watch?v=JZhPlJocTwQ
In VBA to turn full screen view on use below code in workbook open module:
Private Sub Workbook_Open()

Application.DisplayFullScreen = True

End Sub

Open in new window

If it doesn't work then follow this link, which you need to tweak as per your requirement:
Excel VBA: How to hide the excel 2010 title bar in full screen mode?
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Nice Roy :)
Nice solution Roy. I obviously didn't read the whole question :P
Thanks gents