prevent double click title bar

The simplest method may be to use the Workbook_WindowResize event,e.g. (in ThisWorkbook module)

Please Login or Register  to view this content.

To make the Button1_Click macro continue to act as a toggle, you need to modify it slightly:

Please Login or Register  to view this content.

Perhaps such a solution will suffice. But....
When the window is in fullscreen mode, select any cell and edit it (F2 or double-click). When the cell is in edit mode, double-click on the window's title bar.
And it's done.

Artik

Hi Artik,

ThnX for your suggestion. Works like a charm!
Would be nice if we could trap the "before_change" event of the Workbook, to prevent it from going to windowState Normal at all, but this is already a hughe step forward.

I solved this problem
When the window is in fullscreen mode, select any cell and edit it (F2 or double-click). When the cell is in edit mode, double-click on the window's title bar.
by protecting the worksheet and leaving all cells blocked, so no changes are possible.

As in my application, I only allow user interaction in a series of UserForms, this is OK.
Data is written to invisible sheets anyway.

I think we've nailed it!

Grtz, Bart

Since everything is happening on UserForms, why not take it a step further and hide the Excel application. Something along the lines of the code below

Please Login or Register  to view this content.

Although hiding and unhiding should be in a different place (perhaps opening and closing the workbook).

Artik

Hi Artik,

ThnX for your reply and suggestion.

As the application has one visible sheet with an explanation and house-style branding, I have chosen to not hide the application.
But I'll give that a go too, I could put the house-style branding and explanation in a form too.

Grtz Bart

The attached example sets a custom background that covers the Excel application window. You can make the background partially transparent (now set to opaque). In the code you can also see how to remove the UserForm's title bar.

Artik

Oops. I forgot to mention that the file shown earlier is only for the 32-bit version.
Here a corrected "on knee" version that should work on 2010+ versions.

Artik

Works great!