Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Window When Workbook is opened
I need a workbook to always open in a new window. Every time it opens it
covers up the open workbook and I don't want that. This workbook needs to "Stand Alone" in a window. Help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Window When Workbook is opened
This is the normal behaviour, but you can arrange the appearance. You can
arrange the windows, either with WindowArrange.. or manually and after FileSave Workspace. If you really mean that you want the WB to open in a new instance of Excel, you will need some VBA code. Maybe ToolsOptionsViewWindows in taskbar will do. NickHK "David A." wrote in message ... I need a workbook to always open in a new window. Every time it opens it covers up the open workbook and I don't want that. This workbook needs to "Stand Alone" in a window. Help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Window When Workbook is opened
Can I write something invb that Workbook_Open will make it open in a new
window? "NickHK" wrote: This is the normal behaviour, but you can arrange the appearance. You can arrange the windows, either with WindowArrange.. or manually and after FileSave Workspace. If you really mean that you want the WB to open in a new instance of Excel, you will need some VBA code. Maybe ToolsOptionsViewWindows in taskbar will do. NickHK "David A." wrote in message ... I need a workbook to always open in a new window. Every time it opens it covers up the open workbook and I don't want that. This workbook needs to "Stand Alone" in a window. Help! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Window When Workbook is opened
It does open in a new window, but with the size/position of when it was last
saved, which may obscure the window(s) below. You can add code to the Workbook_Open event to controls the windows placement etc. Record a macro whilst perform you desired actions. NickHK "David A." wrote in message ... Can I write something invb that Workbook_Open will make it open in a new window? "NickHK" wrote: This is the normal behaviour, but you can arrange the appearance. You can arrange the windows, either with WindowArrange.. or manually and after FileSave Workspace. If you really mean that you want the WB to open in a new instance of Excel, you will need some VBA code. Maybe ToolsOptionsViewWindows in taskbar will do. NickHK "David A." wrote in message ... I need a workbook to always open in a new window. Every time it opens it covers up the open workbook and I don't want that. This workbook needs to "Stand Alone" in a window. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimize just opened workbook window | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
How to see if the opened workbook is opened by another user ? | Excel Programming |