ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot shift objects off sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/190800-cannot-shift-objects-off-sheet.html)

al

Cannot shift objects off sheet?
 
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

Cannot shift objects off sheet?
 
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

Cannot shift objects off sheet?
 
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





All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com