As an added note:
I am able to create and collapse groups up to a certain cell in the
worksheet without getting the error message. After that, I get the message
for groups I newly create.
Anyone with any ideas of what is going would be apprecated. I definitely
need help on this one. It has got me going in circles.
Carey
"Dave Peterson" wrote:
maybe this'll help:
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769
(Look for runaway comments!)
carey wrote:
While horizontally grouping (outlining) a set of columns, I receive an error
message that reads "Cannot shift objects off of sheet" when I press the ( - )
to collapse the columns. There are no objects that I am aware of, and the
message does not appear when the last column is ungrouped. Also, it appears
when the previous group is collapsed and visa versa. That is, I can collapse
one group and get the message when I try to collapse the other group. It is
really strange the message pops up at some of the oddest times.
Has anyone encountered this before. Anyone's help would be greatly
appreciated.
Thanks.
Carey
--
Dave Peterson