hide application for one workbook
Mark,
Do you want to make it visible when the form closes? If so, just issue an
Application.Visible = True in the closedown
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Application.Visible = True
End Sub
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Mark" wrote in message
...
When i open my file running userform. I operate only in
userform. I want hide application and work on userform:
Application.Visible = False
it's work
but this code unenable show another workbook (sheet) who
run after.
I'd like hide only application with my userform.
Is Excel allow for this action?
Regards
Mark
|