View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Prevent Excel creating new instances of Excel

"Jordi" wrote in message
...
How can I prevent Excel creating new instances of Excel, for differetn
workbooks.
I want having one workbook with some code opened, and all new workbooks

thay
me or other application opens will be in the same instance of Excel where

I
have the code.


Hi Jordi,

This is the way Excel should work already. Are you sure you aren't
confusing different instances of Excel with the appearance of a window in
the task bar for each workbook. This rather annoying feature was added to
Excel 2000 and later versions. Luckily you can turn it off. Choose
Tools/Options/View from the Excel menu and uncheck the checkbox labeled
"Windows in Taskbar". Try this and see if it doesn't fix your problem.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *