Hi all,
I am trying to remove the blue-window border and bar (where the caption is put, and the red close cross 'x') from a modeless userform, so that it looks like a standard label on a sheet.
Does anyone know a statement or property?
Thanx
Hi all,
I am trying to remove the blue-window border and bar (where the caption is put, and the red close cross 'x') from a modeless userform, so that it looks like a standard label on a sheet.
Does anyone know a statement or property?
Thanx
Hello Dr.Ile,
The is no method or property to remove the Window's title bar. To do so requires a macro using API calls. Add a Standard VBA module to your Workbook, and then copy the macro code below and paste it into the module.
Using the Macro:Please Login or Register to view this content.
Place the macro "RemoveTitleBar" in the UserForm's Activate event procedure to remove the caption when the UserForm is shown.
Sincerely,Please Login or Register to view this content.
Leith Ross
Thank you Ross, you save me from ineffective searching for applicable method or property. I never thought of API and most of all, I'm not familiar with it.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks