PDA

View Full Version : Force fullscreen mode



Rejje
12-01-2010, 02:51 PM
Hi again all you vba-smarties!

I wonder if there is any way of forcing fullscreen mode for a workbook? Like a code that checks if any other mode is on. In case so: Fullscreen!

Minimizing should of course be allowed!

mbarron
12-01-2010, 07:56 PM
This will force Fullscreen mode even if the mode is fullscreen
Application.DisplayFullScreen = True

Rejje
12-02-2010, 07:27 AM
Hmm... I don't get it to work though. Where do I place it? I tried to put it in "This Workbook" as below:

Private Sub Workbook_Open2()

Application.DisplayFullScreen = True

End Sub


Gotta remember I'm a learning basic...

I really appreciate all the help I get in here!

mbarron
12-02-2010, 07:50 AM
The 2 in Workbook_Open2() would keep your WorkBook_Open() procedure from running when the workbook is opened.

This worked for me
Private Sub Workbook_Open()

Application.DisplayFullScreen = True

End Sub

Rejje
12-02-2010, 10:44 AM
Yes, it works now. Thank you a lot!

But, works with one major flaw though: One can easily trigger normal screen mode by double clicking the Excel bar on top or just by right click/close fullscreen etc.

I don't want this to be allowed! In case the fullscreen mode is altered in any way I want the workbook to unconditionally get back into fullscreen mode again. How is this done? Is it even possible?

Rejje
12-05-2010, 02:57 AM
Anyone knows?