View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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