pushing window to the front
 

Hello,
I am working on a problem. I need to build a toolbar menu item. When it
will either push a specific workbook to the top. or take the item below it
and push that to the top.

So if my workbook is "Main.xls".
And I have workbooks a,b,c,d,....
When I push the button I want Main to the front.
Then Push again, I want the first in the list pushed up.

The button is easy. But how can you give focus to a document?
Or how can you find the next one in the stack?

thanks

pushing window to the front
 

Here is a quick snippet to tab through the open workbooks:



ActiveWindow.ActivateNext


Mark

"greg" wrote in message
...
Hello,
I am working on a problem. I need to build a toolbar menu item. When it
will either push a specific workbook to the top. or take the item below
it and push that to the top.

So if my workbook is "Main.xls".
And I have workbooks a,b,c,d,....
When I push the button I want Main to the front.
Then Push again, I want the first in the list pushed up.

The button is easy. But how can you give focus to a document?
Or how can you find the next one in the stack?

thanks

pushing window to the front
 

thanks,
I was looking at the window. and seeing if the count is some kind of order.

"Mark Ivey" wrote in message
...
Here is a quick snippet to tab through the open workbooks:



ActiveWindow.ActivateNext


Mark

"greg" wrote in message
...
Hello,
I am working on a problem. I need to build a toolbar menu item. When it
will either push a specific workbook to the top. or take the item below
it and push that to the top.

So if my workbook is "Main.xls".
And I have workbooks a,b,c,d,....
When I push the button I want Main to the front.
Then Push again, I want the first in the list pushed up.

The button is easy. But how can you give focus to a document?
Or how can you find the next one in the stack?

thanks