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

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

"Ed" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

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

--

Dave Peterson

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

On Mar 14, 7:25 am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Maybe...
>
> XL: "Cannot Shift Objects Off Sheet" Error Hiding Columnshttp://support.microsoft.com/default.aspx?scid=kb;en-ca;211769
>
> Remember to look for comments and merged cells.
>
> Ed wrote:
>
> > 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
>
> --
>
> Dave Peterson