Hi

Im putting together a spreadsheet in Excel 97 and the user wants to be able
to use the full screen mode. (window is also maximised)

For most screen in the workbook this is ok as when FullScreenMode is
selected the verticle scroll bar remains visible and due to the nature of
the worksheet no horizontal scrolling is necessary - except on one sheet.

The horizontal scroll bar reamins invisible.

I have checked under tools options and the box is ticked to make it visible
I have also writen a small code module for a button on screen that toggles
the screen into full screen mode and sets the activewindows scrollbar to
visible (see code below) but the scrollbar remains hidden.

You can still move around the screen by using the arrow keys but the user is
adamant they want ot use the scrollbar (he who pays the piper and all
that...)

Any help please - as this is possibly the last (fingers crossed) outstanding
issue on this project.

Many thanks

GreenBoy

Heres the Code:

Sub MyFullScreen()
If Not Application.DisplayFullScreen Then
Application.DisplayFullScreen = True
ActiveWindow.DisplayHorizontalScrollBar = True

Else
Application.DisplayFullScreen = False
End If
End Sub