Full screen solution

[excel_stuff]

Dear listers,

I need to a macro (or a different solution) whereby all my sheets go on full screen view. Perhaps I can have the macro on the front sheet and then all sheets are visible in full screen mode. That would be really appreciated.

Thank you!
ExcelStuff

 

[Somendra Misra]

Hi ExcelStuff,

Use below line to turn it to full screen On & Off

Application.DisplayFullScreen = True
Application.DisplayFullScreen = False

Regards,

 

[ThrottleWorks]

Hi, just wanted to share keyboard shortcut. View --> Full Screen.
Press Esc twice to resume normal.

 

[Somendra Misra]

@ThrottleWorks

Keyboard shortcut in 2010 Alt+W+E.

Regards,

 

[excel_stuff]

Thanks, Thats very kind. However, I want one macro for all sheets (shown on the first sheet). Is that possible?

Thanks
ExcelStuff

 

[Somendra Misra]

@excel_stuff

See the attached file. Is this what you want?

Regards,

 

[ThrottleWorks]

@Somendra Misra

 

[Somendra Misra]

@ThrottleWorks

I expect OP wants this only.

Regards,

 

[Deepak]

Are u looking for this..

Application.DisplayFormulaBar = False
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""RIBBON"", FALSE)"

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
    Application.DisplayFormulaBar = True

 

[ThrottleWorks]

@Somendra Misra , I put cause, I said keyboard shortcut and described mouse movements.

No offence to your code, but I would prefer Alt W E, OP might have a reason to go for VBA which I did not know.
Have a nice day ahead.

 

[Somendra Misra]

@ThrottleWorks

Don't worry.

Regards,

 

[excel_stuff]

Thanks Somendra, this is helpful. Also thanks for Deepak and ThrottleWorks! Prompt and spot on.

 

[Somendra Misra]

Welcome back anytime.

Regards,