Remove Title Bar from a UserForm

[JezLisle]

Is it possible to take the headers of a UserForm. I mean the bit that can have a form name and the little cross on the top right hand corner.

Can this be done, like in Access?

[Leith Ross]

Hello JezLisle,

Yes it can by using API calls. Copy the code below to a Standard VBA module. You will need to place a call to the macro RemoveCaption in your UserForm Activate Event module. A sample appears below the macro code.

Please Login or Register  to view this content.

UserForm Activate Event code

Please Login or Register  to view this content.

[JezLisle]

Thanks for that, it works a treat

[JoJoDo]

Thanks this is just what I'm looking for! I'm fairly new at working with VBA. I pasted the above code into a module and tried to run it but got a message saying that I needed to make changes in order for it to work with a 64 bit system. Could someone please let me know what changes would be required. I'm running Office 2010.

[protonLeah]

JoJoDo,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[Leith Ross]

Here is the macro code for the 64 bit Excel running on Windows 64 bit operating System.

Please Login or Register  to view this content.

If you are running 32 bit Excel on Windows 64 then use this code...

Please Login or Register  to view this content.