How to Hide a single Excel Workbook without hiding the rest

[KarimHosnyHassan]

hi All,

I am working on excel userform, and I am sitting application visibility as false; which makes all excel files as visible.
I was wondering if there is a way to make the visibility of a single workbook as false while the rest of workbooks can still be visible.

 

[Trustee]

Hi there,

Select the Worksheet you’d like to hide by clicking on the tab at the bottom. By holding down theCtrl key while clicking you can select multiple tabs at one time.
On the Home tab, click on Format, which can be found in the Cells group. Under Visibility, select Hide & Unhide, then Hide Sheet.
You can also simply right-click on the tab, and select Hide.
To unhide a worksheet, you just do the opposite. On the Home tab, click on Format in the Cells group and then under Visibility, select Hide & Unhide, then Unhide Sheet.

 

[Tetra201]

I was wondering if there is a way to make the visibility of a single workbook as false while the rest of workbooks can still be visible.

Is this what you need?

Application.Windows.Item("Your_Window_Name.xxxx").Visible = False

 

[KarimHosnyHassan]

Is this what you need?

Application.Windows.Item("Your_Window_Name.xxxx").Visible = False

I believe you got my point but to me more clear on your code I will use exactly the same changing xxxxx to my file mane if I am not mistaken right?
Sorry I not too genius like you guys

 

[Tetra201]

I believe you got my point but to me more clear on your code I will use exactly the same changing xxxxx to my file mane if I am not mistaken right?
Sorry I not too genius like you guys

Your_Window_Name.xxxx should be exactly the same as you see in the Excel title bar just before the - Microsoft Excel.
If you see, for example, Book1, use "Book1"; if you see Book1.xlsx, use "Book1.xlsx".

 

[KarimHosnyHassan]

I believe you got my point but to me more clear on your code I will use exactly the same changing xxxxx to my file mane if I am not mistaken right?
Sorry I not too genius like you guys

I meant, where would I enter my File name (workbook name)

 

[KarimHosnyHassan]

Hi Tetra201
I have used your code; and actually what happened is that yes my file is invisible, but there is an empty window with Microsoft excel is opened in the background. which I was wondering if I may vanish as well

 

[Tetra201]

Is this what you need?

Application.WindowState = xlMinimized

 

[KarimHosnyHassan]

It only minimize it wish is better but still it is visible. I don't want to push on that but do you have another way that can make it completely disappear