Columns Problem?

[MrBill]

I have made use of most all of the columns available thru IV, minus aprox 10
cols.

with minus 5 cols, at one time was able to expand 1 column size (to trick
xl? column space available so I can: cut / past / insert columns).

Error getting: cannot shift objects off sheet.
I now have difficulty inserting, etc. with 15 cols expanded / cannot reduce
size of columns. (turning into a mess)

is it some kind of terminator problem where number vs size of columns, can
be fixed? thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2-25c6add1a28a&dg=microsoft.public.excel.misc

 

[Luke M]

Make sure there isn't something in the last column (data, specific
formatting, etc). The easiest way is probably to select column IV, delete it
(not just clear contents) and then insert a column where desired.

 

[Gary Brown]

Run this. It might help. The explanation is longer than the macro :O> ...

'/=================================/
' Sub Purpose: change all shapes to 'Move and Size'
' to stop error message when hiding columns.
' The 'Cannot shift objects off sheet.' error is usually
' caused by Comments that have the object positioning
' property set to 'Dont move or size with cells'.
' By changing this to 'xlMoveAndSize', columns/rows
' can be hidden without generating an error
'
'from MSKB article # 211769
'Cannot shift objects off sheet" error message when you hide
' columns in Excel '
' http://support.microsoft.com/default.aspx?scid=kb;en-us;211769
'/=================================/
'
Public Sub Change_All_Shape_Properties2MoveAndSize()
Dim shp As Shape

On Error Resume Next

For Each shp In ActiveSheet.Shapes
shp.Placement = xlMoveAndSize
Next shp

End Sub
'/=================================/

 

[MrBill]

thanks, that worked. did not think would find answer.. and took while to
try, thought would be destructive by resizing (but did not change my comment
sizes).

 

[MrBill]

hi, I tried the kb, gets me when they write answer steps in paragraph form
(backwards, wrong, missing steps).

so do you think I need to change a setting in regard to this? what I got out
of it was:

from:
The option Nothing (hide objects) is selected in the Display options for
this workbook section in the Excel Options dialog box.

To: (guessing wrong)
(options, view, comments, check: none ??)


note: excel 2002, thanks much.