PDA

View Full Version : Solved: minimizing all windows except mine



olorin
11-28-2005, 04:45 PM
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
11-29-2005, 02:15 AM
This will do it:Application.Windows(ThisWorkbook.Name).WindowState = xlMaximized

olorin
11-29-2005, 11:01 AM
brilliant..............thanx a lot

geekgirlau
11-29-2005, 04:13 PM
Don't forget to mark this thread as "Solved" (Thread Tools | Mark Thread Solved)