Grouping and Objects

[Kevin H. Stecyk]

Hi,

I inherited a spreadsheet. When I group certain rows, I get the message,
"Cannot shift objects off sheet." As far as I can tell, there are no
objects in the rows. I can group other rows in the same sheet without
difficulty, but some rows I can't.

Is there a way for me to see what Excel is complaining about?

I am using XL 2003.

Thank you.

Best regards,
Kevin

 

[Dave Peterson]

maybe this'll help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769

 

[Biff]

Try this

F5>Special>Objects>OK

Biff

 

[Kevin H. Stecyk]

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

Hi Dave,

I used the macro suggested in the article...

Sub Test()
Dim s As Shape
On Error Resume Next
For Each s In ActiveSheet.Shapes
s.Placement = xlMoveAndSize
Next
End Sub

Problem solved. I didn't find the problem object, but the problem is fixed.

Thank you!

Regards,
Kevin

 

[Kevin H. Stecyk]

Biff wrote...

Try this

F5>Special>Objects>OK

Biff

Thank you!

Regards,
Kevin