How to Hide a single Excel Workbook without hiding the rest

KarimHosnyHassan

New Member
Joined
Dec 10, 2016
Messages
11
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.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Trustee

New Member
Joined
Nov 23, 2016
Messages
16
Hi there,

Select the Worksheet you’d like to hide by clicking on the tab at the bottom. By holding down the
Ctrl 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

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,631
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?
Code:
Application.Windows.Item("Your_Window_Name.xxxx").Visible = False
 
Last edited:

KarimHosnyHassan

New Member
Joined
Dec 10, 2016
Messages
11
Is this what you need?
Code:
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

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,631

ADVERTISEMENT

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".
 
Last edited:

KarimHosnyHassan

New Member
Joined
Dec 10, 2016
Messages
11

ADVERTISEMENT

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

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,631
Is this what you need?
Code:
Application.WindowState = xlMinimized
 

KarimHosnyHassan

New Member
Joined
Dec 10, 2016
Messages
11
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,284
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top