LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Multiple Windows in Single file

How do you determine which window is active in the activeworkbook when the
activeworkbook has more than one window. The problem I have is when I try to
activate a windows of a file that has more than one window, I get an error
(makes sense, since it doesn't know which window to select). Is there a way
to assign the activewindow of the activeworkbook to an object and later just
activate the object. Any other ideas are welcome.

Alternatively can I use something live workbooks("my book")windows(1).activate

Thanks for any suggestions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Single Excel instance with multiple windows BrianB Excel Discussion (Misc queries) 0 March 2nd 10 06:41 PM
Printing multiple worksheets to one single pdf file Gene Excel Discussion (Misc queries) 2 December 19th 06 06:32 PM
closing file with multiple windows open gvanhoy3 Excel Worksheet Functions 1 November 15th 06 06:31 PM
Single text file imported to multiple worksheets Lynn Bales Excel Worksheet Functions 2 September 21st 06 10:42 PM
Extracting a single file from a zip archive which has multiple files [email protected] Excel Programming 0 July 31st 06 12:26 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"