hidding xl workbooks

[kxlvba]

Same here I have a different issue. I'm using the following code to hide and show the excel file. For me I need to have the control to hide and show the excel file after doing something on a userform.
Using Application.Visible = True / False hides all workbooks. I just need to hide the workbook which has the form and keep rest of the open workbooks open. Any advice.

 

[pgc01]

Hi kxlvba

You can use the window's visible property.

Try this code:

Sub HideWindow()
Dim wnd As Window

Set wnd = ActiveWindow
wnd.Visible = False
MsgBox "The window is hidden"
wnd.Visible = True

End Sub

Does this help?
PGC

 

[kxlvba]

No, I have an excel file..where I've placed a button to show the form. So once the form is up, Application.Visible = False is executed within the click code and hides all excel files.
Then when I'm through filling the form and click on Close the code Application.Visible = False is executed and shows all workbooks.
So if I use the above code, after the workbook gets hidden it doesn't proceeds ahead with the remaining macro code. Gives me a runtime error 1004.
So, there should be something related to Application.Visible...which should only hide a particular workbook.

 

[Legacy 98055]

You cannot hide a workbook. There is no visible property of a workbook. If you hide the application, you will hide everything it contains. You need to work in several instances of Excel which may be possible if a bit tricky. See this post and others.

Opening xl in hidden mode via VBS script