Re: Getting an error message "Cannot shift objects off of sheet"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Carey,

Ignore the extraneous, floating:

> In tests


---
Regards,
Norman



"Norman Jones" <normanjones@xxxxxxxxxxxxxxxxxxx> wrote in message
news:%23uBZ5asfFHA.2424@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Carey,
>
> If Dave is out of guesses, chances are bleak indeed
>
> However, a possible, 'clutching at straws' idea:
>
> In the course of this thread, you have been adamant that there are no
> comments and no objects on your sheet.
>
> How have you checked? How do you *know*?
>
> If, for example, you relied on F5 (Edit | Goto) | Special, this would fail
> if there were hidden objects. So if there were hidden shapes (pictures,
> drawing objects , checkboxes, text boxes etc etc) and no visible objects,
> the F5... method would report "No objects found"
>
> If, therefore, you have not tried a more rigorous method, can I suggest
> that you try running the following simple macro:
>
> In tests
>
> '=====================>>
>
> Sub CleanUp()
>
> Dim cmt As Comment
> Dim shp As Shape
> Dim ws As Worksheet
>
> Set ws = ActiveSheet
>
> On Error Resume Next
> ws.Cells _
> .SpecialCells(xlCellTypeComments).Delete
> On Error GoTo 0
>
> For Each shp In ws.Shapes
> shp.Delete
> Next
>
> End Sub
>
> '<<=====================
>
> It is very likely that it will not help, but with options running low,
> perhaps it is worth trying .
>
> ---
> Regards,
> Norman
>
>
>
>
> "carey" <carey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:9F7E5734-E187-43E2-A7FF-B68662E4AB54@xxxxxxxxxxxxxxxx
>> Thanks for your help.
>>
>> "Dave Peterson" wrote:
>>
>>> Sorry, I don't have any more guesses.
>>>
>>> carey wrote:
>>> >
>>> > Nope, nothing was selected or found. The sheets are free of objects
>>> > and
>>> > comments.
>>> >
>>> > I also copy pasted to a new workbook file. That didn't help either.
>>> > Around
>>> > the G? columns I get the messages when recreating the groups.
>>> >
>>> > Any other ideas? This is becoming very frustrating.
>>> >
>>> > Carey
>>> >
>>> > "Dave Peterson" wrote:
>>> >
>>> > > How about
>>> > > edit|goto|special
>>> > > check objects.
>>> > >
>>> > > Did anything get selected?
>>> > >
>>> > >
>>> > >
>>> > > carey wrote:
>>> > > >
>>> > > > 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.aspx?scid=kb;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
>>> > > > >
>>> > >
>>> > > --
>>> > >
>>> > > Dave Peterson
>>> > >
>>>
>>> --
>>>
>>> Dave Peterson
>>>
>
>


.

Relevant Pages