Lock window maximized and fullscreen mode

[cbrf23]

Hi,

I need to lock the screen in fullscreen mode if a user does not have a certain security level. I can get the screen to be fullscreen, and hide the menus, and I've also disabled all keys except the ones they need for data entry, as well as disabled right click. I though I had it all covered, but I realized that if you put the mouse all the way up at the top of the screen and dbl-click, or click and drag, then the excel application window will exit fullscreen mode.

I've tried:

Private Sub Workbook_WindowResize(ByVal Wn As Window)
        If Not oSettings.AllowMenus Then
                If Application.DisplayFullScreen = False Then Application.DisplayFullScreen = True
        End If
End Sub

But this seems to only be triggered by the workbook's window within the application. Is there anyway to accomplish the same thing with the excel application window?

 

[bensonsearch]

is this for the workbook or a userform?

 

[cbrf23]

For the application window. No form.

 

[Hermanito]

You are trying to make a so-called dictator application. This is not the easiest thing to (correctly) pull off...
I can only refer you to the chapter on dictator applications in the 'Professional Excel Development' book by Bullen, Bovey & Green, which contains everything you always wanted to know but were afraid to ask about dictator apps