View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Userform - Title bar formatting options and other attributes

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