cannot shift objects off sheet

[Guest]

I tried all the suggestions already posted but still get the error 'cannot
shift objects off sheet', when I tried to hide one of my columns. Anyone
know any workarounds?

 

[Bob Phillips]

Including this one?

http://support.microsoft.com?kbid=170081
XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Yes, I tried that one. I don't have any comments...don't think that is the
issue

 

[Debra Dalgleish]

If you press Ctrl+End, what cell is selected? Way past the cells that
contain data?

If you reset the used range, it may solve the problem. There are
instructions here:

http://www.contextures.com/xlfaqApp.html#Unused

 

[Guest]

Thanks Debra but I already tried that. Ctrl+End takes me to the last cell
with data in it, but I still get the error

 

[Debra Dalgleish]

Perhaps William's suggestion in the following posting will help:

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

He wrote:
'=======================
"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"
'========================

 

[Guest]

there appears to be some maximum # of cells that can be hidden...anyone know
if this is true

 

[Guest]

Thanks but that doesn't help either...

Perhaps William's suggestion in the following posting will help:

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

He wrote:
'=======================
"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"
'========================