Hi S,

Thanks for the solution. Exactly what i was looking for. One small thing - I
wish the fullscreen toolbar does not show up on the screen for my user(s) to
click on it. I would like them to use the spreadsheet without coming out from
the fullscreen.

Thanks

Robin



"Incidental" wrote:

Hi Robin

if you put the following code in the "Thisworkbook" module it will
automatically change when you open the file

Option Explicit

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
Application.CommandBars("Worksheet Menu Bar").Enabled = False
End Sub

S