View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Need workbook w/ VBA to open in new & separate application window

I don't follow if you do or do not want each wb to open in new Excel
instances, look at Ignore Remote Requests in Tools Options General
(don't be confused with the Show Windows in taskbar setting which gives the
impression of multiple instances).

Toolbars in new instances will be as saved in the toolbar file (*.xlb) when
the last of all instances was closed.

I think what you want is for a customized toolbar setting whenever a certain
wb is active. Simply set or restore these in the ThisWorkbook Activate &
Deactivate (& BeforeClose) events respectively of the given wb.

Regards,
Peter T

"mikeolson" wrote in message
...
I need to be able to have workbook A and workbook B open. I will open
workbook A first by double clicking the workbook A.xls which opens Excel.
Workbook A contains no macros. Then I need to be able to open workbook B
which contains macros that remove all toolbars, menus. When I do this

now,
the toolbars are removed in both workbooks. Is there a way to open up
Workbook B in a new application where the Macros will not effect both or

all
open workbooks. I realize I can open 2 instances of Excel & navigate to

each
workbook A & B, but his method is apparently too cumbersome for some other
users. So, double click workbook A one App opens, double click workbook B

a
second App opens, macros remove toolbars in workbook B window only. I did
change one of the settings so each workbook opens in a new window but
apparently they are still in one instance of Excel, I would like each

double
click to open a new instance of Excel loading it's default settings.

Thank
you for your help with this one.