About Us

Kurt[_2_]

Thanks Earl, I'll give it a try.

....kurt

"Earl Kiosterud" wrote in message
...
Kurt,

I don't know specifically about 2007, but in general, Excel likes to move
graphics around. We think the cleaning lady came in and changed the code
just before Excel was finalized for release. Grouping them solves the
problem. Select them, right-click one, and choose Group.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Kurt" wrote in message
...
In Excel 2007 when loading a workbook (originally created in Excel 2000),
objects like text boxes, rectangles, etc will frequently be placed on the
sheet in the wrong place. I have posted an example at
http://65.243.151.82. Notice in the "Correct" screenshot the row of
buttons. You can click any of the buttons (which correspond to sheet
names) and go to that worksheet. The current active worksheet ("WA" in
the example) is indicated by the red background text box filling the
space of the button (and circled in the example).

In the "Incorrect" example, notice how the text box is shifted up and to
the left, and is also smaller. This happens randomly. In some cases the
text boxes on all of the worksheets are misplaced exactly as the example
(relative to their original position). Other times it might just be one
or two sheets. If I close and re-open the workbook, all is fine again (at
least for a while). I've tried deleting and re-creating the text boxes,
but the problem persists. This seems to be a bug. I have other sheets
where a text box will be in the correct position if opened with a
pre-2007 version of Excel, but much lower on the sheet when opened in
2007. Is there a place to report bugs and such?

...kurt

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CANNOT SHIFT OBJECTS IN SHEET	MrBill	Excel Discussion (Misc queries)	0	April 28th 10 07:13 PM
Different objects-same sheet	gunshybars	Excel Discussion (Misc queries)	1	August 29th 08 02:03 PM
Misplacement of objects on a sheet	Kurt[_2_]	Excel Discussion (Misc queries)	2	March 4th 07 06:57 PM
Dim sheet objects	Mats Samson	Excel Programming	3	February 14th 06 04:55 PM
Unable to remove Sheet objects in the Microsoft Excel Objects	Adrian[_7_]	Excel Programming	1	August 26th 04 10:49 PM

Menu

About Us