WindowState = xlMinimized does not show name of workbook

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
893
From within a "mother" workbook I open a series of other, linked workbooks. I use the following code:

VBA Code:
' Open the first workbook
   Set wb1 = Workbooks.Open(filePath1)

   ' Minimize the first opened workbook
   wb1.Windows(1).WindowState = xlMinimized

   ' Open the second workbook
   Set wb2 = Workbooks.Open(filePath2)

   ' Minimize the second opened workbook
   wb2.Windows(1).WindowState = xlMinimized

As planned all the other workbooks open minimized. The point is however that the minimized workbooks when pointed at only show a grey field with in the midlle the Excel logo and on top only the application name but not the workbook name. To identify the workbook I have to click it, but then it maximizes too. When I minimized it again the name of the workbook and an image of the workbook's appearance stays visible when pointed at. Is there a way to minimized the workbooks ánd at least show the name of the workbook?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
the minimized workbooks when pointed at only show a grey field with in the midlle the Excel logo and on top only the application name
Do you mean when pointing at the excel icon on the windows taskbar ?
I couldn't replicate the issue. I use excel 2016 on Windows 10 and when I point at the excel icon on the taskbar, all minimized workbooks show their respective names.
 
Upvote 0
Larache, as you describe. I need to double ckick to get a name and a visual. I use Excel 365 on a corporate version of Windows.
 
Upvote 0
I tried a few thing such as maximizing the window before minimizing; nothing worked. As a work around I added “Switch windows” to the quick access toolbar; it does the trick.
 
Upvote 0
Solution

Forum statistics

Threads
1,223,162
Messages
6,170,431
Members
452,326
Latest member
johnshaji

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
Back
Top