|
HIDE Workbook whilst VBA Form Open
Is there anyway that i can have an input VBA form open and ready to input data but not actually show the workbook to be open Steve -- Steve_Dyson ------------------------------------------------------------------------ Steve_Dyson's Profile: http://www.excelforum.com/member.php...o&userid=16522 View this thread: http://www.excelforum.com/showthread...hreadid=314311 |
HIDE Workbook whilst VBA Form Open
Use
Application.Visible = False and Application.Visible = True at the appropriate places in your form management code. "Steve_Dyson" wrote: Is there anyway that i can have an input VBA form open and ready to input data but not actually show the workbook to be open Steve -- Steve_Dyson ------------------------------------------------------------------------ Steve_Dyson's Profile: http://www.excelforum.com/member.php...o&userid=16522 View this thread: http://www.excelforum.com/showthread...hreadid=314311 |
| All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com