Thread: HIDE Workbook whilst VBA Form Open
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
  
Posts: 400
Default 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


Reply With QuoteReply With Quote