Hello, I know this thread is long since dead, but I have the same issue as user rooky. (Whose attitude was indeed not that great ).

I have a workbook which I intend to host on our company's server, which can be accessed by anyone internally. The workbook will display various charts of the company's revenues, profits, etc. I would like to provide the directory path to this file to various employees and corporate relations. I would like to limit them to one specific view, upon opening the workbook: Fullscreen, no toolbars, no scrollbars.

I have written the macros to do this, and it works perfectly. Upon opening (and enabling macros) this view is restored. However, if the user minimizes this full screen view, or resizes the window to non-fullscreen, all toolbars and scrollbars reappear.

My code, in ThisWorkbook:

Private Sub Workbook_Activate()
    On Error Resume Next
    With Application
        .DisplayFullScreen = True
        .CommandBars("Worksheet Menu Bar").Enabled = False
    End With
     
End Sub
 
Private Sub Workbook_Deactivate()
    On Error Resume Next
    With Application
        .DisplayFullScreen = False
        .CommandBars("Worksheet Menu Bar").Enabled = True
    End With
     
End Sub

Private Sub Workbook_SheetActivate(ByVal Sh As Object)



If TypeName(Sh) = "Worksheet" Then

    Sh.ScrollArea = "A1:AF40"

End If



End Sub
Private Sub Workbook_WindowResize(ByVal Wn As Window)
Application.DisplayFullScreen = True
End Sub
The bottom part, I had added on royUK's line. I have also examined the other workbooks you posted, and the problem persists.

I'm also willing to bite the bullet that perhaps this is impossible- making a spreadsheet not only locked and un-editable, but also keeping all toolbars and Excel locked down too. I'm also afraid that once I do this, that the person I give the copy to (to maintain the original before hosting it on server) will be unable to edit it at all!

Any advice? Is it possible to lock down a workbook so entirely that the user can do nothing more than look at a fullscreen view, not even change views or access any menus?

Thank you for your help in advance! New user, registered to post this question.