Shifting Objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joseph Hughes - 28 Jun 2007 20:51 GMT

this is probably a bsaic question. I created a worksheet that has multiple
columns of data. Some of the columns have a check box inserted in them. Now
I would like to hide some of the other columns, but I am getting an error
message telling me I "cannot shift objects off sheet". Can I hide columns
once I put check boxes somewhere in the spreadsheet? How?

Reply to this Message

Gord Dibben - 28 Jun 2007 21:02 GMT

Read this KB Article and follow the instructions for "moving and sizing"

http://support.microsoft.com/default.aspx?scid=kb;en-us;211769

Gord Dibben MS Excel MVP

>this is probably a bsaic question. I created a worksheet that has multiple
>columns of data. Some of the columns have a check box inserted in them. Now
>I would like to hide some of the other columns, but I am getting an error
>message telling me I "cannot shift objects off sheet". Can I hide columns
>once I put check boxes somewhere in the spreadsheet? How?

Reply to this Message

SpreadsheetBrian - 28 Jun 2007 21:05 GMT

On Jun 28, 3:51 pm, "Joseph Hughes"<joseph.hugh...@honeywell.com>
wrote:

> this is probably a bsaic question. I created a worksheet that has multiple
> columns of data. Some of the columns have a check box inserted in them. Now
> I would like to hide some of the other columns, but I am getting an error
> message telling me I "cannot shift objects off sheet". Can I hide columns
> once I put check boxes somewhere in the spreadsheet? How?

I have encountered this recently.

When I ran into this, I was trying to hide Column L through Column
IV. What was preventing me from doing so was that I had a form
control partially overlapping Column L. You cannot cause a form
control or any part of a form control to suddenly not have a cell
behind it.

Were I to have hidden the columns I chose, the form control (a
checkbox) would have bled off the rightmost column and hung over the
gray spreadsheet background. That is not allowed.

Make sure that your "Hide" operation won't be leaving a control "off
the spreadsheet"

Brian Herbert Withun

Reply to this Message