|
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com