Hi Phillip;
The title bar is a skin; if you remove the title bar, you must change
dimensions of the window consequently.
hCaption = Me.Height - Me.InsideHeight - ((Me.Width - Me.InsideWidth) / 2)
Me.Height = Me.Height - hCaption

MP

"Phillip Reeves" a écrit dans le message de
...
Hi

I'm using Excel to build a custom application, and use a
class module to muck around with forms to do things such
as remove/resize the titlebar, remove the maximize
button, etc. (it is based upon one I downloaded from one
of the Excel MVP sites).

My problem is that when I remove the titlebar of a form,
the form height remains the same, so that it doesn't
display as designed (i.e. with an extra bit at the
bottom). Yes, I adjust the height in code by a fixed
amount, but that only works cleanly on my OS display
settings (XP style). If my app runs on Windows 2000
(with the shorter titlebars), the form heights are not
adjusted properly.

So, I need to know which windows .dll to use (and how) to
determine the user's titlebar height setting in twips (or
whatever measurement scale Excel VBA uses for form
heights). I guess it's user32.dll with GetSystemMetrics
(maybe!), but which item number is it?

Hope that makes some sense to somebody!

Many thanks, Phillip