Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Full Screen code

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I currently use the code below to make a spreadsheet go to full screen mode when opened...

    Private Sub Workbook_Open()
    Application.DisplayFullScreen = True
    End Sub

    However, I want to make the screen return to normal view when the spreadsheet is closed. Someone did give me some code to add to the end of that listed above, but it didn't work (and i've since lost it !!). Can anyone help ?? Cheers.

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-07 01:32, RichieF wrote:
    I currently use the code below to make a spreadsheet go to full screen mode when opened...

    Private Sub Workbook_Open()
    Application.DisplayFullScreen = True
    End Sub

    However, I want to make the screen return to normal view when the spreadsheet is closed. Someone did give me some code to add to the end of that listed above, but it didn't work (and i've since lost it !!). Can anyone help ?? Cheers.


    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.DisplayFullScreen = False
    End Sub

    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •