If you use Tools/Options/View, you'll see the bottom section is all about the
window, not the workbook. If you use Window/New Window, then you have 2
windows of the active workboo. Each window can have different settings, like
ghe first could have sheets1 & 2 selected (in group mode), and the 2nd can
have sheets 2, 3, and 5 selected (in group mode). This is why there's VBA
code for Activewindow.SelectedSheets instead of
ActiveWorkbook.SelectedSheets, for example.
Go to the immediate window and type activewindow. (include the period)
and notice the intellisense choices. Then try activeworkbook. (with the
period)...a totally different set of choices.
HTH

"clara" wrote:

Hi all,

Could you tell me what is the function of the Window Object and how to
control it in code?

Clara
--
thank you so much for your help