Open workbook in full screen mode

[mrroland]

Hi,

I like a particular workbook to open in full screen mode.

How would I do that?

Cheers,
Roland

 

[Von Pookie]

Put this in the ThisWorkbook module:

Private Sub Workbook_Open()
    Application.DisplayFullScreen = True

To close full screen view, just change true to False.

(You can get that line of code from the macro recorder, too )

 

[mrroland]

Ok,

I found the answer by using the search function. I will try that option more often in the future.

Sub Autpen()
Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Visible = False
ActiveWindow.DisplayHeadings = False
End Sub
'
Sub Auto_Close()
Application.DisplayFullScreen = False
ActiveWindow.DisplayHeadings = True
End Sub
Cheers,
Roland

 

[mrroland]

Thank you Von Pookie for your answer .

It seems that your code works better than the one i found .

The only thing I can't figure out is:
When the workbook opens it will open at full screen. Just the way I want it. But when I close the workbook and I open any other workbook it will still open at full screen. For me that is no problem but i know a few around my office who may find this annoying. Is there a way to disable the full screen mode when the workbook is closed?

Cheers,
Roland

 

[Von Pookie]

Just make a new sub in the ThisWorkbook module:

Private Sub Workbook_Close()

Application.DisplayFullScreen = False

End Sub

 

[mrroland]

Kristy

Thank you for your answer.

I more or less figured it had to be something like that. I have pasted your code into a new sub in ThisWorkbook module. Maybe i am doing something wrong but when i close the workbook and completely turn off excel, then start up excel again in opens up in full screen mode. Can you tell me what i am doing wrong.

I appreciate your interest in my problem.

Cheers,
Roland

 

[Von Pookie]

I've never really played with full screen before, so I'm not sure. But one thing to check is to make sure you are putting the code for fullscreen in the ThisWorkbook module for the particular workbook you are working with and not the Personal.xls.

If it is in Personal.xls, it will run every time Excel does.

 

[mrroland]

Kirsty,

OK, here it is, I am a total beginner regarding anything close to VBA

Here is what I do.
I open brand new workbook. press alt F11. dubble click on "thisworkbook"
Paste the both given codes and press save.

When I close the workbook and then open it again it will open in full screen. So far, so good. When I close the work book an open any other workbook it will still open up in full screen mode

Now I noticed that if I open up any particular workbook, go to view, full screen mode, and close the work book (I do not save it). Then open up the work book, it will still open up in full mode.

Maybe what I want is not possible???

Cheers,
Roland

 

[Von Pookie]

When you double-click the "ThisWorkbook" module: is it listed under your workbook's name, or under Personal?

Example:

In the picture above, you want to put the code in the ThisWorkbook module under the heading "Book1" (this will be whatever your current file name is.

If it's under Personal, remove the code.

 

[mrroland]

Kirsty,

I think i have it the way you describe. In my case it doesn't work. Don't bother though. Ihave gave up the idea, it was just to make it more nice. But with different screen resolutions it might not have worked even with full screen mode. Thank you for showing interest in my problem.

Cheers,
Roland