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?

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)


"AAA" wrote in message
...
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?

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

"Bob Phillips" wrote:

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)


"AAA" wrote in message
...
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?

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 he

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

AAA wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

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 he

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

AAA wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

http://groups.google.ca/groups?hl=en...%40tkmsftngp09

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"
'========================

AAA wrote:
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" wrote:


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 he

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

AAA wrote:

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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"AAA" wrote:

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" wrote:

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 he

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

AAA wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks but that doesn't help either...


"Debra Dalgleish" wrote:

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

http://groups.google.ca/groups?hl=en...%40tkmsftngp09

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"
'========================

AAA wrote:
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" wrote:


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 he

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

AAA wrote:

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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html