View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Controling Your Customized Form? Can I minimize it?

In Excel 2000 and later, you can show the form modelessly. Try

UserForm1.Open vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mcasteel" wrote in
message ...

When my customized form is running in Excel, I'm not able to
access the
worksheet behind my form. Is there a way to enable this? Also
presently I'm unable to work in any Excel file (even files
outside of
my application). Is there some way to get around all of this?

Thank you.

Mike K. Casteel
- Michigan


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile:
http://www.excelforum.com/member.php...o&userid=15698
View this thread:
http://www.excelforum.com/showthread...hreadid=314433