Hiding Excel main title bar

[adam]

Hi Anyone,

I'm using the following code to view the excel page in full screen. But with this code I can't get rid of the blue Excel title bar at the top of the screen.

Code: Select all

Sub DisplayFullScreen()
Application.DisplayFullScreen = True
End Sub

And for this reason I did try by adding the line

Code: Select all

Application.DisplayTitleBar = False

But it does not help to do the job.

Does anyone know of a way to hide the top title bar?

Thanks in advance.

[HansV]

Of course

Application.DisplayTitleBar = False

doesn't work, DisplayTitleBar doesn't exist. Programming is a bit different from magic, unfortunately.

Copy the code from the attached text file into a new module. You can then use Title_Hide to hide the title bar and Title_Show to display it again.

Code.txt

The code has been adapted from Ivan Moala's code in Is it possible to hide the Excel Title Bar? - MrExcel Message Board.

[adam]

Thanks Hans. I too did see the code but couldnt make it work. I guess now it does.

By the way

Programming is a bit different from magic, unfortunately.

Nice quote.