"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 *