Can't hide far right columns:"Shift objects off sheet"??

[Ed]

I've got some constants and such in the far right-most columns, where
my average user wouldn't have any need of going. Just to add an extra
measure of safety, though, I wanted to either hide the columns or set
the column width to something like 0.1. Excel won't let me do either
- the error message is "Can't shift objects off the sheet." But there
are no "objects" - just values in cells. What am I looking at? Is
there another way to accomplish this?

Ed

 

[Joerg]

Which version? Should be no problem in XL2003.
BTW: Far right is not a good solution since it inflates your Used Range. You
might pay a heavy price in terms of file size. Better use "nearer" cells or
a dedicated hidden page.

You can also define your constants without using any cells: Just use Insert
=> Name = Define. Into the box "Names in Workbook" input a name for your
constant (e.g. "rate"), into the box "Refers to" input the value of the
constant (e.g. "=1.3"). Press "OK" and now you can use your named constant
in your worksheet as usual (e.g. "=3*rate").

Cheers

Joerg Mochikun

 

[Dave Peterson]

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769

Remember to look for comments and merged cells.

 

[Ed]

Thanks, Dave. That did the trick. I did have some merged cells, but
they posed no problem, so I assume it was the comments.

Ed