A
A Parks
In a multitab worksheet, we have a rectangluar autoshape on each sheet. The
rectangluar shapes are not moved or resized with cells. The shapes are set to
no fill.
On any sheet, if you want to select a range within the rectangle on that
sheet, there is no problem. But if you want to link from one sheet to another
-- i.e type = for a cell's contents and then go to another sheet to select a
cell or cells -- you are not permitted to select a cell within that other
sheet's autoshape. One may select a range that overlaps the autoshape,
however. One can also manually enter the range, too.
The problem goes away if the rectangle on the sheet to which we want to link
is hidden.
We would like to not have to hide the autoshapes AND not have people
manually entering the ranges.
Any suggestions? Is this a bug?
rectangluar shapes are not moved or resized with cells. The shapes are set to
no fill.
On any sheet, if you want to select a range within the rectangle on that
sheet, there is no problem. But if you want to link from one sheet to another
-- i.e type = for a cell's contents and then go to another sheet to select a
cell or cells -- you are not permitted to select a cell within that other
sheet's autoshape. One may select a range that overlaps the autoshape,
however. One can also manually enter the range, too.
The problem goes away if the rectangle on the sheet to which we want to link
is hidden.
We would like to not have to hide the autoshapes AND not have people
manually entering the ranges.
Any suggestions? Is this a bug?