Excel in full screen

[faxof]

can i make my excel sheets full screen?
ie, no toolbars and menu bars etc
all i want on the screen is the excel sheets and the sheet tabs, i'd like to get rid of everyting else.
i know i can do it in access by getting rid of the borders (this also covers the start menu bar too) but i dont know if i can do it in excel.
but when i open a different excel workbook i want them to appear again.

any idea?

 

[SQLScholar]

Try going to this

thread68-341650 a question i asked near the bottom, and was replied. i got it to work

Regards

Dan

 

[Loomah]

hi faxof

without code goto View>Full Screen

or you could use this little snippet
Sub FullScreen()
With Application
.DisplayFullScreen = True
.CommandBars("full screen&quot.Visible = False
End With
End Sub

As I think I mentioned in the thread Plank is refering to above, getting rid of the Menu Bar is another story and I don't know how off the top of my head.

Depending on how you would want to use this you may want to put the code into the Workbook open, before close, activate & deactive events. Obviously change true to false on deactivate and omit the commandbar line.

Happy Friday
;-) If a man says something and there are no women there to hear him, is he still wrong?