[Excel 2003]

I use userforms in my spreadsheets.

I have a main "Dashboard" userform from which I call up other userforms.

What I would like is to be able to remove the title bar from the main
userform.

Is there a way to do this? Ideally, I would still like to retain the close
button in the corner (and even change its format (to look like Windows 95
close button icon)

I would be interested to learn of any links to tutorials or examples on how
to format userform attributes of these kind.

can anyone help?

Thanks, Roger

The best you can do is to simply remove the caption the frame will still
remain.

Roger on Excel;579790 Wrote:
[Excel 2003]

I use userforms in my spreadsheets.

I have a main "Dashboard" userform from which I call up other
userforms.

What I would like is to be able to remove the title bar from the main
userform.

Is there a way to do this? Ideally, I would still like to retain the
close
button in the corner (and even change its format (to look like Windows
95
close button icon)

I would be interested to learn of any links to tutorials or examples on
how
to format userform attributes of these kind.

can anyone help?

Thanks, Roger


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160327

Microsoft Office Help

Hi Roger,

What I would like is to be able to remove the title bar from the main
userform.

Go to http://www.oaltd.co.uk/Excel/SBXLFrm.htm and download formfun.zip.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

Roger,
have a look at this site:
http://www.oaltd.co.uk/Excel/Default.htm

There is an item in the ist "formFun.zip" you can download for free. Should
give you some ideas what you can be done with userforms.
--
jb


"Roger on Excel" wrote:

[Excel 2003]

I use userforms in my spreadsheets.

I have a main "Dashboard" userform from which I call up other userforms.

What I would like is to be able to remove the title bar from the main
userform.

Is there a way to do this? Ideally, I would still like to retain the close
button in the corner (and even change its format (to look like Windows 95
close button icon)

I would be interested to learn of any links to tutorials or examples on how
to format userform attributes of these kind.

can anyone help?

Thanks, Roger

See the example code and downloadable function library at
http://www.cpearson.com/excel/formcontrol.aspx . This code will allow
you to do what you want and lots more stuff.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Mon, 7 Dec 2009 08:57:01 -0800, Roger on Excel
wrote:

[Excel 2003]

I use userforms in my spreadsheets.

I have a main "Dashboard" userform from which I call up other userforms.

What I would like is to be able to remove the title bar from the main
userform.

Is there a way to do this? Ideally, I would still like to retain the close
button in the corner (and even change its format (to look like Windows 95
close button icon)

I would be interested to learn of any links to tutorials or examples on how
to format userform attributes of these kind.

can anyone help?

Thanks, Roger