Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 28th 04, 08:02 PM
 
Posts: n/a
Default Help - Cannot shift objects off sheet problem

I have a spreadsheet that used to work fine. But now when I try to
reduce the size of a column (or hide it) I get a message "cannot shift
objects off sheet". There are no objects that I am aware of and it
happens on every column, even ones that I have changed the width in
the past. Can anyone help?

  #2   Report Post  
Old December 28th 04, 09:09 PM
Carole O
 
Posts: n/a
Default

Go to Search For (above everyone's questions), and key in "cannot shift
objects". There are a lot of people with the same question, and you should
be able to find a solution.

HTH,
Carole O

"[email protected]" wrote:

I have a spreadsheet that used to work fine. But now when I try to
reduce the size of a column (or hide it) I get a message "cannot shift
objects off sheet". There are no objects that I am aware of and it
happens on every column, even ones that I have changed the width in
the past. Can anyone help?

  #3   Report Post  
Old December 28th 04, 11:22 PM
Gord Dibben
 
Posts: n/a
Default

Read here for info.

http://support.microsoft.com/default...b;en-us;211769


Gord Dibben Excel MVP


On Tue, 28 Dec 2004 15:02:00 -0500, [email protected] wrote:

I have a spreadsheet that used to work fine. But now when I try to
reduce the size of a column (or hide it) I get a message "cannot shift
objects off sheet". There are no objects that I am aware of and it
happens on every column, even ones that I have changed the width in
the past. Can anyone help?


  #4   Report Post  
Old December 29th 04, 11:54 AM
 
Posts: n/a
Default

Thanks for the help, but it doesn't work. I took a section of 15
columns of the spreadsheet and "cleared all" . I then tried resizing
just one column in the middle and I still got the message. That column
and several to the right and left were cleared of everything, but I
still got the "cannot shift objects" messager. There were no objects,
I cleared everything. Any thoughts? Thanks.










On Tue, 28 Dec 2004 15:22:29 -0800, Gord Dibben <gorddibbATshawDOTca
wrotg:

=Read here for info.
=
=http://support.microsoft.com/default.aspx?scid=kb;en-us;211769
=
=
=Gord Dibben Excel MVP
=
=
=On Tue, 28 Dec 2004 15:02:00 -0500, [email protected] wrote:
=
=I have a spreadsheet that used to work fine. But now when I try to
=reduce the size of a column (or hide it) I get a message "cannot shift
=objects off sheet". There are no objects that I am aware of and it
=happens on every column, even ones that I have changed the width in
=the past. Can anyone help?

  #5   Report Post  
Old December 29th 04, 12:19 PM
 
Posts: n/a
Default

i just tried clearing all comments from the whole spreadsheet and the
problem went away. This is a very large sheet with hundreds of
comments. Is there some way I can universally change their properties
to allow resizing. Doing each one individually would take hours.
Thanks.







On Tue, 28 Dec 2004 15:22:29 -0800, Gord Dibben <gorddibbATshawDOTca
wrotg:

=Read here for info.
=
=http://support.microsoft.com/default.aspx?scid=kb;en-us;211769
=
=
=Gord Dibben Excel MVP
=
=
=On Tue, 28 Dec 2004 15:02:00 -0500, [email protected] wrote:
=
=I have a spreadsheet that used to work fine. But now when I try to
=reduce the size of a column (or hide it) I get a message "cannot shift
=objects off sheet". There are no objects that I am aware of and it
=happens on every column, even ones that I have changed the width in
=the past. Can anyone help?



  #7   Report Post  
Old December 29th 04, 06:34 PM
Gord Dibben
 
Posts: n/a
Default

To autosize all comments on a worksheet........

Public Sub Comment_Size()
Dim cmt As Comment
Dim cmts As Comments
Set cmts = ActiveSheet.Comments
For Each cmt In cmts
cmt.Shape.TextFrame.AutoSize = True
Next
End Sub

I don't believe that re-sizing Comments will assist with the problem.

Setting the "move and size with cells" property is what eliminates the error
message.

See the methods at the KB article I originally posted.

Text from that article............

Note Running the following macro sets the property that is mentioned in Method
1 for all the objects on the active worksheet. Because this setting causes
objects to resize when the rows and the columns that are associated with the
object are resized, it can cause unexpected results when it displays the
objects on the worksheet if you resize the rows and the columns. Consider this
problem before you run the macro in your file.

To change the property on all the comments on the active worksheet, run the
following macro:

Sub Test()
Dim s As Shape
On Error Resume Next
For Each s In ActiveSheet.Shapes
s.Placement = xlMoveAndSize
Next
End Sub

End article text.........................

Gord


On Wed, 29 Dec 2004 07:19:18 -0500, [email protected] wrote:

i just tried clearing all comments from the whole spreadsheet and the
problem went away. This is a very large sheet with hundreds of
comments. Is there some way I can universally change their properties
to allow resizing. Doing each one individually would take hours.
Thanks.







On Tue, 28 Dec 2004 15:22:29 -0800, Gord Dibben <gorddibbATshawDOTca
wrotg:

=Read here for info.
=
=http://support.microsoft.com/default.aspx?scid=kb;en-us;211769
=
=
=Gord Dibben Excel MVP
=
=
=On Tue, 28 Dec 2004 15:02:00 -0500, [email protected] wrote:
=
=I have a spreadsheet that used to work fine. But now when I try to
=reduce the size of a column (or hide it) I get a message "cannot shift
=objects off sheet". There are no objects that I am aware of and it
=happens on every column, even ones that I have changed the width in
=the past. Can anyone help?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking to an Entire Sheet Chaplain Doug Links and Linking in Excel 2 December 24th 04 07:39 AM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM
Worksheet copy problem - local names Jack Sheet Excel Discussion (Misc queries) 2 December 2nd 04 10:02 AM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017