HIDE Workbook whilst VBA Form Open

[Steve_Dyson]

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

 

[Guest]

Use

Application.Visible = False and Application.Visible = True

at the appropriate places in your form management code.

 

[Corcodel]

Ok. I used Application.Visible = False, but I have a problem.
Now I want to view this sheets for modification.
Is any way to revert at initial stage?
Where can I introduce Application.Visible = True because I don/t view code window?

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?action=getinfo&userid=16522
> View this thread: http://www.excelforum.com/showthread.php?threadid=314311
>
>