Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Can This Be Done

    Hello Everyone

    I am designing a scheduling system for my work using Excel 2000. In order to make the interface secure, I have already disabled all toolbars, right-click options, tabs, etc. However, the problem I have is that when you double-click on the top bar of excel (the one which displays the file name, the minimize, restore, and close buttons), it will restore down the size of the window. I need to have this window always stay maximized. I have already disabled the three buttons on that bar (minimize, restore, and close), but I can't find a way to disable the double-click on that bar restoring it down. I'm not sure if an Application-Level event can be used to disable this feature. Does anyone have any suggestions/solutions to this situation?


  2. #2
    Join Date
    Dec 2003
    San Diego, CA
    Welcome the the Board!

    Why not use the View-->Full Screen option?

    Application.DisplayFullScreen = True

    That'll get rid of the Title Bar all together.

    Or you could try something like:
    Private Sub WindowResize()
        Application.WindowState = xlMaximized
    End Sub
    Private Sub On_DoubleClick()
        Application.WindowState = xlMaximized
    End Sub
    Hope that helps,


    EDIT: TYPO & I didn't actually try those snippets; just thoughts.
    Last edited by Smitty; 03-24-04 at 22:36.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts