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:
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?
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?