ExcelBanter - Opening Workbooks Mininmized

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Opening Workbooks Mininmized (https://www.excelbanter.com/new-users-excel/4553-opening-workbooks-mininmized.html)

DME

Opening Workbooks Mininmized

Is there a setting that when I open a workbook it is automatically
minimized? I have 15 workbooks that I open all at once and have to minimize
each one seperately. Thanks.

Ken Macksey

Hi

In the Workbook_Open sub of each workbook put

Application.ActiveWindow.WindowState = xlMinimized

Save and close the file. Now each time it is opened, it will open minimized.

HTH

Ken

All times are GMT +1. The time now is 01:03 PM.