pane & active cell


S

sali

excel2000, when having multiple [2 or 4] panes on sheet [view is divided]:
a) range copy
making a range [active cell in one pane, shift+click on other pane], and
right click for copy, if mistakenly clicking the visible part of range on
other pane the range is disappearing. i must click range *only* in pane
having active cell!
is it true? may i adjust excel to allow me to click range in whatever pane
it is visible?
b) pane scroll
when scrolling a pane with mouse wheel, is it possible to have "mouseover"
effect, to scroll a pane mouse is over [like outlook express mail client is
doing], without having to click inside pane to select it for scrolling?

for these things to have workable, do i need to upgrade to some higher
excel?

thanks.
 
Ad

Advertisements

D

Dave Peterson

a. The current selection is limited to the activewindow.

Do you know macros? If you go into the VBE and start a macro that uses
something like:

dim rng as range
set rng = selection

Put your cursor on selection and hit F1. You'll see VBA's help for
Selection. There's an applies "button" at the top. You'll see that
Selection applies to a window (not worksheet) or the whole application
(essentially the active window).

b. xl2002 added the live scrolling that you want.

excel2000, when having multiple [2 or 4] panes on sheet [view is divided]:
a) range copy
making a range [active cell in one pane, shift+click on other pane], and
right click for copy, if mistakenly clicking the visible part of range on
other pane the range is disappearing. i must click range *only* in pane
having active cell!
is it true? may i adjust excel to allow me to click range in whatever pane
it is visible?
b) pane scroll
when scrolling a pane with mouse wheel, is it possible to have "mouseover"
effect, to scroll a pane mouse is over [like outlook express mail client is
doing], without having to click inside pane to select it for scrolling?

for these things to have workable, do i need to upgrade to some higher
excel?

thanks.
 
Ad

Advertisements

S

sali

Dave Peterson said:
a. The current selection is limited to the activewindow.

Do you know macros? If you go into the VBE and start a macro that uses
something like:

dim rng as range
set rng = selection

Put your cursor on selection and hit F1. You'll see VBA's help for
Selection. There's an applies "button" at the top. You'll see that
Selection applies to a window (not worksheet) or the whole application
(essentially the active window).

b. xl2002 added the live scrolling that you want.


thanks.
i understand shown object hierarchy.
but on contrary, i was imaging window just as "viewport" which purpose is
only to map cell coordinates to user's display, and that worksheet is the
object that *actualy* processes a selection.
since excel displays selection and range on each pane where applicable, i
hoped it could be enough smart to understand that clicking on blue selection
area on other [inactive] pane is referring the same [previously] selected
area.

but, never mind.



excel2000, when having multiple [2 or 4] panes on sheet [view is
divided]:
a) range copy
making a range [active cell in one pane, shift+click on other pane], and
right click for copy, if mistakenly clicking the visible part of range on
other pane the range is disappearing. i must click range *only* in pane
having active cell!
is it true? may i adjust excel to allow me to click range in whatever
pane
it is visible?
b) pane scroll
when scrolling a pane with mouse wheel, is it possible to have
"mouseover"
effect, to scroll a pane mouse is over [like outlook express mail client
is
doing], without having to click inside pane to select it for scrolling?

for these things to have workable, do i need to upgrade to some higher
excel?

thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top