-
Solved: minimizing all windows except mine
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?
-
This will do it:[VBA]Application.Windows(ThisWorkbook.Name).WindowState = xlMaximized[/VBA]
K :-)
-
brilliant..............thanx a lot
-
Don't forget to mark this thread as "Solved" (Thread Tools | Mark Thread Solved)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules