How can I change the display to full screen everytime the sheet is selected and normal when we leave.

U

USAMax

Well-known Member
Joined
May 31, 2006
Messages
846
Office Version
  1. 365
Platform
  1. Windows
I have a controls worksheet with a lot of functions tied to it and I don't want anyone changing anything, plus I need the real estate.

I know this is the code to go to full screen:
Code: 
    Application.DisplayFullScreen = True

Are there Sheet_Select and Sheet_Unselect functions?

Is there a way to prevent them from leaving the Full Screen mode?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
You must log in or register to reply here.

Similar threads

A
  • Question
First VBA Project - is there a better way to write this code?
Replies
0
Views
2K
akshay27
A
J
  • Question
Excel crashing when entering date in userform
Replies
0
Views
901
jptaz
J
R
  • Question
How to Exit Full Screen when Closing
Replies
3
Views
3K
Momentman
Momentman
J
  • Question
Can I get help troubleshooting this macro?
Replies
5
Views
1K
rlv01
R
Jambi46n2
  • Question
Macro Works When I Press Play in Visual Basic But Doesn't With IRibbonControl
Replies
4
Views
386
Jambi46n2
Jambi46n2

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

Share this page

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
Back
Top