Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open two tiled windows on workbook_open
Good afternoon.
I'm creating a workbook that will automatically open two windows (one for reference data that I don't want to scroll along with the other) to be used by several users. The complicating factor is that each user will name his/her copy differently, so I don't know in advance the name (s)he'll give it. I've created a string variable called strWorkbookName, but can't figure out how to get it into a variation of: Windows("Book2:1").Activate At least I think that's the right direction, and the statement with which the problem lies. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
How do I auto run my macro upon open of file....Workbook_Open() is NOT working? | Excel Programming | |||
Spreadsheet takes 20 seconds to open before Workbook_Open | Excel Programming | |||
workbook_open not being called when I open the excel file | Excel Programming | |||
Private Sub Workbook_Open() not running on open | Excel Programming |