Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controling Your Customized Form? Can I minimize it?
When my customized form is running in Excel, I'm not able to access th worksheet behind my form. Is there a way to enable this? Als presently I'm unable to work in any Excel file (even files outside o my application). Is there some way to get around all of this? Thank you. Mike K. Casteel - Michiga -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=31443 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controling Your Customized Form? Can I minimize it?
UserForm1.Open vbModeless
should be UserForm1.Show vbModeless -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controling navagation of a form | Excel Discussion (Misc queries) | |||
Minimize the VB form | Excel Programming | |||
Minimize the VB form | Excel Programming | |||
Minimize a form | Excel Programming | |||
How to minimize a form using VB | Excel Programming |