Error = 'Cannot Shift Objects Off Sheet'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MClark - 28 Apr 2005 20:28 GMT

I'm getting this error when trying to hide a number of columns in Excel.
Anyone know why? Thanks!!

Reply to this Message

Alan - 28 Apr 2005 22:53 GMT

> I'm getting this error when trying to hide a number of columns in
> Excel. Anyone know why? Thanks!!

Most likely cause is that you have comments in cells that are set
*not* to move with the cells or are out to the right in an area that
you would be hiding.

Move the cells comments so that they won't be in the hidden part of
the worksheet after you do the hide operation, and also make sure that
they are set to 'move' with the cells.

HTH,

Alan.

Reply to this Message

MClark - 28 Apr 2005 23:28 GMT

Alan,

Is there an Excel function that can make comments 'Move' with the cells or
do i have to manually move them to ensure they're not opening up way to the
right, for example...b/c even by manually moving the comments, I can't seem
to get the columns to collapse & hide...thx again for your help.

> > I'm getting this error when trying to hide a number of columns in
> > Excel. Anyone know why? Thanks!!
[quoted text clipped - 10 lines]
>
> Alan.

Reply to this Message

Alan - 29 Apr 2005 01:49 GMT

> Alan,
>
[quoted text clipped - 3 lines]
> moving the comments, I can't seem to get the columns to collapse &
> hide...thx again for your help.

You can select all the comments (Goto - Special - Comments) and change
the properties of them all like that I think.

You would have to do that manually for each sheet unless you tried to
code it in VBA somehow.

HTH,

Alan.

Reply to this Message