"Cannot Shift Objects Off Sheet" Error

Denise · Feb 28th, 2002, 09:14 AM

I'm trying to hide columns in a spreadsheet, but I keep getting the error "Cannot Shift Objects Off Sheet". I've deleted all columns to the right and rows below the data and saved the file, but the error keeps popping up.

Why would objects be shifted off the sheet when I HIDE a column?

Any suggestions or solutions?

Thanks.

Denise

NateO · Feb 28th, 2002, 11:43 AM

It sounds odd, sounds more like you're inserting a column. If you're using vba, are using something like:

Columns("J:L").EntireColumn.Hidden = True

Regards, Nate

[ This Message was edited by: NateO on 2002-02-28 10:44 ]

Ivan F Moala · Mar 1st, 2002, 02:09 AM

You probably have some shape / object
Check to see if you have any....including
Comments. If you do then just change the shapes property to Move & size with cell.

Just as a side note Comments are a part of the
shapes collection....so you don't neccessarily have to have the Box you can change this to any shape you want.

HTH
Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 09:14 AM	#1
Denise New Member Join Date: Feb 2002 Location: M&T Bank Posts: 18	I'm trying to hide columns in a spreadsheet, but I keep getting the error "Cannot Shift Objects Off Sheet". I've deleted all columns to the right and rows below the data and saved the file, but the error keeps popping up. Why would objects be shifted off the sheet when I HIDE a column? Any suggestions or solutions? Thanks. Denise

Feb 28th, 2002, 11:43 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	It sounds odd, sounds more like you're inserting a column. If you're using vba, are using something like: Columns("J:L").EntireColumn.Hidden = True Regards, Nate [ This Message was edited by: NateO on 2002-02-28 10:44 ]

Mar 1st, 2002, 02:09 AM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	You probably have some shape / object Check to see if you have any....including Comments. If you do then just change the shapes property to Move & size with cell. Just as a side note Comments are a part of the shapes collection....so you don't neccessarily have to have the Box you can change this to any shape you want. HTH Ivan