LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Misplacement of objects on a sheet

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
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
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


All times are GMT +1. The time now is 06:38 AM.

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

About Us

"It's about Microsoft Excel"