[al]

When trying to hide columns I get this error message..."cannot shift objects
off sheet."
When hiding columns in another worksheet, this message does not appear!

Any ideas what's going on?

Al

[Jim Rech]

Any object in or sometimes near the columns to be hidden can cause this.
That includes cell comments, which is the thing that gets me all the time.

--
Jim
"Al" wrote in message
...
| When trying to hide columns I get this error message..."cannot shift
objects
| off sheet."
| When hiding columns in another worksheet, this message does not appear!
|
| Any ideas what's going on?
|
| Al

[al]

I have many columns that when trying to hide produce this error...I'll
investigate when back in the office tomorrow! Thanks!

"Jim Rech" wrote:

Any object in or sometimes near the columns to be hidden can cause this.
That includes cell comments, which is the thing that gets me all the time.

--
Jim
"Al" wrote in message
...
| When trying to hide columns I get this error message..."cannot shift
objects
| off sheet."
| When hiding columns in another worksheet, this message does not appear!
|
| Any ideas what's going on?
|
| Al