View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default excel positioning in points for autoshapes

I guess the short answer is no, there is no ruler as such. The distances can
be measured in pixels per inch, but even that varies from one product to
another i.e. 72 ppi, 96 ppi, etc. The best solution I can think of is trial
and error using the references of Top and Left with pixels until you find
what your screen measurements are for ppi. Then you can use that as your
guideline for placing shapes. It might be an optical illusion, but it seems
that on my monitor the same number of pixels are shorter from top to bottom
than from side to side. Good Luck!

"Kelzina" wrote:

thanks for the advice... but im not wanting to know the points for a web page
im only wanting to know the points for excel, and how you would figure it out
what point measurement you'd need for a perticular section in excel, ie some
form of ruler etc ... is there such a thing??
--
"The difference between Possible and Impossible is the measure of ones will"


"JLGWhiz" wrote:

this web site might give you some help:

http://webdesign.about.com/gi/dynami...nen/units.html

"Kelzina" wrote:

i want to know how to determine where (in Points) to position an autoshape
using vba (without recording a macro).
aparently shapes lines etc use a point system to position themselves using
start x axis, start y axis, end x asis and end y axis.

1. is it possible to view how many point there in in relation to a cell
reference, and
2. is it even possible to figure out the point system without recording a
macro???

--
"The difference between Possible and Impossible is the measure of ones will"