remove header from userform?[blue bar @ top]

[chrisdarl]

Hi, i am wanting to remove the header bar @ the top of the userform so
that the user will not be able to move the userform around. and it
looks neater. Anyway can anyone give me a bit of code to do this in
VBA?

Many thanks Chris

 

[Jake Marx]

Hi Chris,

No built-in way to do this, but you could check out formfun.zip from this
page on Stephen Bullen's site:

http://www.bmsltd.ie/Excel/SBXLPage.asp

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Tom Ogilvy]

Go to Stephen Bullen's site and down load Formfun.zip

unzip it and look at the code in the workbook.

http://www.bmsltd.ie/Excel/Default.htm

 

[chrisdarl]

thank you jake for the fast reply. I'll take a look.

Chri