New Window When Workbook is opened

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
This is the normal behaviour, but you can arrange the appearance. You can
arrange the windows, either with Window>Arrange.. or manually and after
File>Save 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 Tools>Options>View>Windows in taskbar will do.

NickHK
 
Can I write something invb that Workbook_Open will make it open in a new
window?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Excel 2013 menubar incompatibility? 1
Unwanted workbooks on startup 2
Save As and new workbook new name used in existing code 8
Excel is removing Macros from workbook 3
Opening a list of Excel files and run a macro in each 17
Copy cell value from one worksheet to matching worksheet in another workbook 4

Back
Top