Is there a way to lose the bar off the top of the window (the one with the
caption, close and maximise buttons embedded in it). I just want to have the
screen filled with my app and no clue that it is excel.

Kind regards, Mark

Mark Stephens wrote:
Is there a way to lose the bar off the top of the window (the one with the
caption, close and maximise buttons embedded in it). I just want to have the
screen filled with my app and no clue that it is excel.

Kind regards, Mark


View - Full Screen

In VBA use ....

Application.DisplayFullScreen = True

or set it false to reverse it.


--
Cheers
Nigel



"Mark Stephens" wrote in message
...
Is there a way to lose the bar off the top of the window (the one with the
caption, close and maximise buttons embedded in it). I just want to have
the
screen filled with my app and no clue that it is excel.

Kind regards, Mark

Nigel

I don't think Full Screen will do what the OP wanted. I suspect that API
calls will be needed as there is no way through VBA to remove the icon, etc
from either the application or workbook window

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Nigel" wrote in message
...
In VBA use ....

Application.DisplayFullScreen = True

or set it false to reverse it.


--
Cheers
Nigel



"Mark Stephens" wrote in message
...
Is there a way to lose the bar off the top of the window (the one with
the
caption, close and maximise buttons embedded in it). I just want to have
the
screen filled with my app and no clue that it is excel.

Kind regards, Mark

If your app is comprised of userforms, you could just hide Excel
altogether. E.g.,

Application.Visible = False ' True to restore


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Mark Stephens" wrote in message
...
Is there a way to lose the bar off the top of the window (the
one with the caption, close and maximise buttons embedded in
it). I just want to have the screen filled with my app and no
clue that it is excel.

Kind regards, Mark