How to understand the Window Object?
 

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

How to understand the Window Object?
 

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

How to understand the Window Object?
 

Hi Bob,

Could you fingure out a case in which grouped sheet should be used?

Clara
--
thank you so much for your help


"Bob Umlas, Excel MVP" wrote:

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

How to understand the Window Object?
 

If you want to apply the same change to many sheets.
Group all your worksheets and in A1 enter sth like =B1+C1 and hit Enter the
formula will then appear in every sheet that you grouped.

HTH
knut
"clara" skrev i melding
...
Hi Bob,

Could you fingure out a case in which grouped sheet should be used?

Clara
--
thank you so much for your help


"Bob Umlas, Excel MVP" wrote:

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