Opening Workbooks Mininmized

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.
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Password protect new workbooks from template 0
Visio to Excel 0
Need Help with Macro Security 1
Automatically closing slave workbook when main workbook is closed... 0
Workbook Window will not maximize 1
You'll need a new app to open this about link 1
Use a master workbook to carry over changes to multiple workbooks 1

Top