disable title bar double click action

[rjplante]

I have a spreadsheet in Excel 2007 and I have the macro language that expands the window to full screen, removes the function of the maximize and minimize window buttons, and disables the close functions. I would like to disable the ability of the user to double click on the title bar and have it maximize or minimize the window. How do I do this? I would also like to have the window cover the task bar at the bottom of the screen. Is this even possible?

Thanks,

Robert

 

[John_w]

To disable the double-click on the title bar I think you would have to trap the mouse events, using Windows API calls, allowing the event if it isn't on your Excel window. An alternative would be to remove the title bar altogether, again using the Windows API.

For the task bar, there is an auto-hide setting in the Windows GUI, which makes it appear only when the mouse pointer approaches the bottom of the screen. It may be possible to change the auto-hide setting programmatically using the Windows API.