Opening Workbooks Mininmized

  • Thread starter Thread starter DME
  • Start date Start date
D

DME

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