Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating from javascript - can't get Excel window to front | Excel Programming | |||
Need macro bring internet explorer window to front | Excel Programming | |||
Setting to Keep a Spreadsheet in Front Window | Excel Worksheet Functions | |||
Pushing results HELP! | Excel Programming | |||
Pushing my luck | Excel Worksheet Functions |