View Single Post
  #2   Report Post  
Ken Macksey
 
Posts: n/a
Default

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