"Max" wrote:

Try the response by PaulB in this thread:
http://tinyurl.com/8ytqu
where he posts a sub MakeSquare for the purpose

And here's a link to a sample file
with the sub implemented to play with:
http://www.savefile.com/files/2349832
MakingCellSquares_Sub_PaulB.xls

Steps
--------
Select the range (or try selecting entire sheet)
Run the sub by pressing Alt+F8,
select "MakeSquare" in the Macro dialog, click Run
Answer the inputbox by entering say: 0.1,0.1
then click OK
When the sub completes, you'd get the result !

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"fauler Frosch" wrote in message
...
How can I format a cell as an exact square? If I choose the same number
for
the hight and the width, I get a rectangle not a square. Yes, I can drag
the
width and hight of a cell with the mouse, than I watch the numbers of
pixel
in the quickinfo and after I copy the format to other cells. But, is there
a
better way?

Thank you very much. That means, I have to use a macro! There is no easy
way? Beginners like me should take the mouse?!