Prev: auto complete only for one row down?
Next: Grouping difference between 2003 and 2007
From: MrBill on 3 May 2010 20:55
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.


"Gary Brown" wrote:

> 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
> '/=================================/
>
> --
> Hope this helps.
> If it does, please click the Yes button.
> Thanks in advance for your feedback.
> Gary Brown
>
>
>
> "MrBill" wrote:
>
> > 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/community/en-us/default.mspx?mid=1248edb5-67a3-444e-a332-25c6add1a28a&dg=microsoft.public.excel.misc
First  |  Prev  | 
Pages: 1 2
Prev: auto complete only for one row down?
Next: Grouping difference between 2003 and 2007