Toggle full screen

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Hi,
Try this. Press Alt+F11 to open the vb editor.
(If the 'VBAProject' is not showing in the left of the screen then hit the 'Project Explorer' button on the toolbar to display it.)
Find your workbook name in the project explorer and select 'ThisWorkbook' below it. (You may have to expand the Microsoft Excel Objects tree for the workbook first.)
From the menu, choose Insert > Module. Paste all 3 of these routines into the standard module that opened up. (The white area on the right.)
Code:
Sub auto_open()
' assign our own macro to the F11 key:
  Application.OnKey "{F11}", "sbToggleFullscreen"
End Sub


Sub auto_close()
' set the F11 action back to default
  Application.OnKey "{F11}"
End Sub


Sub sbToggleFullscreen()
  If Application.DisplayFullScreen Then
    Application.DisplayFullScreen = False
  Else
    Application.DisplayFullScreen = True
    ' to not show the fullscreen commandbar
    ' uncomment the following line
    ' Application.CommandBars("Full Screen").Visible = False
  End If
End Sub

Press Alt+Q to close the vb editor, save & close the workbook and re-open it to try it out.

Hope it helps.
 

Ghais Chatila

New Member
Joined
Aug 7, 2009
Messages
21
Thanks Half Ace,

i tried the procedure, and then it asked me to save my workbook as a macro enabled doc. I did that saved, closed and reopened, and F11 still opens up a chart. Please follow up. Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,133,387
Messages
5,658,516
Members
418,450
Latest member
KarlP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top