Daniel, don't you mean opening same file in two or more windows?
You can do that by clicking on Window-New Window. Then arrange according ur
need.

"DanielWalters6" wrote:

Thankyou, but I don't regularly use the same macros.

Thank you for your help all the same. Have made a mental note of a few way
in which I can hide a workbook in future.

P.s. You know how you can make two workbooks open at the same time? Eg. when
creating a shortcut to a file, can you make it so that it opens two?

Or when I was to open one workbook, another one would open hidden.

Thank's for the help

Dan
--
iPod's ROCK!


"Gord Dibben" wrote:

Dan

As an alternative you could always "Hide" Personal.xls so's it opens but is
hidden from view.

With it open go to WindowsHide then close Excel. Click "Yes" when asked to
save changes to Personal.xls.

Then any global macros will be available for any and all open workbooks.

That is the function of the Personal.xls workbook.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 13:42:03 -0700, "DanielWalters6"
wrote:

After many failed attemtps (not sure why)

It finally worked.

thank you for your time

Dan