How to run and XLSm file always in full screen?

[aneshdas]

Friends,

Can anybody tell me how to Run an XLSM file always in full screen even though the user pressed the escape button?

Any help will be highly appreciated.

 

[afalifi]

Friends,

Can anybody tell me how to Run an XLSM file always in full screen even though the user pressed the escape button?

Any help will be highly appreciated.

You can hide the ribbon and taskbar with code. But I dont remember codes. I guess it could be with application code. Please have a search on google about hiding ribbon and taskbar. It may help you.

 

[aneshdas]

Application.DisplayFullScreen = True helps. But when user press the escape key, it will will restore to normal position.

 

[afalifi]

Application.DisplayFullScreen = True helps. But when user press the escape key, it will will restore to normal position.

This link may help you.

Excel escape key

"Use the OnKey command, the following will 'disable' the escape key on the keyboard.Application.OnKey "{ESC}", "No_Change"
and this command
Application.OnKey "{ESC}"
will turn it back on."

 

[aneshdas]

Thanks @afalifi . It works perfectly now!
Thanks again.

 

[afalifi]

Thanks @afalifi . It works perfectly now!
Thanks again.

You are welcome