fullscreen

Hello, When I'm in FullScreen, I would like to display the StatusBar. If I write: Application.DisplayStatusBar = True it doesn't work. I have Excel 2007. Thanks to explain me what.

Hi I am using this code to run my userform in fullscreen. I have 7 ppl using the document and it works for all but 1. Sub Fullscreen() 'fullscreen för userform Dim lngWinState As XlWindowState With Application .ScreenUpdating = False lngWinState = .WindowState...

Hi all, I have some code that hides menus etc. amongst other things but when I minimise then restore, the menus are back. code: Private Sub workbook_open() ActiveWindow.WindowState = xlMaximized Sheets("UserView").Visible = True Worksheets("UserView").Activate Application.DisplayFullScreen =...

Hi, I have gathered the following code to open a workbook in Fullscreen, with no ribbon, no column headers. The code also restores them back when the workbook is closed. I have hidden the sheet tabs manually by stretching the scroll bar over them. Objective is aesthetics not security...