Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel 2003 shapes positioning & sizing

Status
Not open for further replies.

hofburg

MIS
Feb 15, 2002
27
AT
Hi,
I have an Excel2003 file with a macro producing a number of rectangles and textboxes and setting column width & row height so that a set of shapes fits in one cell.
All works fine.

The workbook is on a network and should be used by different people.

Now, when the file is opened & macro started on a different PC, the shapes produced are somewhat wider and do not fit in a cell anymore. The height remains ok though. (All PCs involved are WinXP + Office 2003).

Why are the 140 points I want to have (or whatever measure the shapes are defined in) not of the same size on any PC?.

Thanks for any hints.

ZH
 
In addition to above:
the rectangle produced by a macro has width = 141

On my PC a right-click on the AutoForm produced in this way shows the width of 7,2 cm; on another one the thing gets 7,41 cm wide.

Thanks.

ZH
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top