Not sure, but you could try this:

Assuming you mean different sheets within the same book

Click Window New Window
(Repeat above as many times as the # of different sheets - 1)

Click Window Arrange Tiled (say) OK
(Tinker with the other options in the dialog to taste)

Voila, you've got the views you asked for .. (?)

Note: To close the new windows created,
click the "x" at the top right corner of each window
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Yoga" wrote in message
...
I just want to know which options should be enabled to open different exel
sheets in different windows by opening single Excel application