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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.