Grouping and Objects
 

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

maybe this'll help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769


"Kevin H. Stecyk" wrote:

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

Try this

F5SpecialObjectsOK

Biff

"Kevin H. Stecyk" wrote in message
...
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 wrote...
maybe this'll help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;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

Biff wrote...
Try this

F5SpecialObjectsOK

Biff


Thank you!

Regards,
Kevin