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!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

size units for AutoShape objects (inch or cm?)

Status
Not open for further replies.
mikeJW

mikeJW

Mechanical
Joined
May 2, 2003
Messages
21
Location
GB
I use scaled drawings in Excel. Sometimes the Autoshape object properties are in inches and at other times they are in cm.
How can I force Excel to use cm as the size units for an AutoShape Object?
Many thanks.
 
Sort by date Sort by votes
More info - but still no easy solution.
When I load Excel from VB the default Autoshape units are inches. No Regional settings.
When I load Excel from the desktop it first loads my Personal.xls which has regional settings and so uses cm for the Autoshape size.
 
Upvote 0 Downvote
My guess would be that it depends on the regional settings in your system (via the Control Panel, Regional Settings, Number tab). In your case you may want to set the measurement system to Metric.

Cheers,

Joerd
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

n8cole
  • Locked
  • Question Question
Looking for an AI that will help me create a chemical functional group database
Replies
7
Views
3K
pierreick
pierreick
BhagyeshVashi
  • Locked
  • Question Question
Need a rename macro for excel
Replies
11
Views
1K
sdz
sdz
Kenja824
  • Locked
  • Question Question
Im looking for some formula help please --- Again. lol
2
Replies
37
Views
2K
Kenja824
Kenja824
Kenja824_home
  • Locked
  • Question Question
Excel - Looking for a formula please
Replies
14
Views
1K
BridgeSmith
BridgeSmith
vinodnx7
  • Locked
  • Question Question
Micro to compare two excel file for mirror change
Replies
4
Views
1K
vinodnx7
vinodnx7

Part and Inventory Search

Sponsor

Back
Top