When grouping, what causes the error "Cannot shift objects off the sheet"

M

Mark E. Philpot

Shifting off the sheet refers to moving beyond the
boundaries of the spreadsheet. You may be using a macro to
group.
 
B

BrianB

Re reply from Enterprise Project Consulting
'--------------------------------------------------------

I think this advertising violates the principles of the forum. It ha
probably stopped a valid answer - I rarely read messages that alread
have replies
 
D

Debra Dalgleish

Since grouping involves hiding columns, the following MSKB article may help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?id=211769

Also, Dave Peterson posted this advice:
'================
Someone with the same problem posted back that their comments were
getting resized causing the trouble.

Maybe enabling: Tools|Options|View|Comment and indicator
(at least for a little bit will help.)
'========================

Or, perhaps William's suggestion in the following posting will help:

http://groups.google.com/groups?hl=en&selm=#SyiwlGICHA.2580@tkmsftngp09

He advised the following:
'=======================
"if you have a button on your worksheet, right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"
'========================


Kirk wrote:
 
A

A Levchuk

Great post - quick and efficient fix of the problem I've been sturuggling with for a while. Thanks!!
 
Top