Solved: minimizing all windows except mine

[olorin]

Hi Again,
Where I work there are a few people on the local network and they all use Excel to some degree or another, and often have excel workbooks open as they try and view mine.
I would like to be able to minimize all the open excel windows and just leave mine maximized when they open mine.
Is this possible with the "workbook_open()" routine?

[Killian]

This will do it:[VBA]Application.Windows(ThisWorkbook.Name).WindowState = xlMaximized[/VBA]

[olorin]

brilliant..............thanx a lot

[geekgirlau]

Don't forget to mark this thread as "Solved" (Thread Tools | Mark Thread Solved)