Romuald,
The default font size applies to new workbooks opended after you have
changed the default not to existing sheets that you have already saved.
In a macro you could run this code
Sub SetDefault()
With Cells
.Font.Size = 8
.Columns .AutoFit
End With
End sub
Which will change all cells to 8 point and set columns to the maximum width
of data in each column. If you have several sheets in a workbook then you
need to cycle through all worksheets and apply the same procedure.
Cheers
Nigel
"Romuald" wrote in message
...
Hello,
I have defined the default police size to 8 in my Excel
2002. Then I have created a workbook. Columns and rows
headers of all sheets are fitted to 8.
Now I have define the default police size to 10. When I
open the previous created workbook, the police used to
display columns and rows headers are still fitted to 8.
Moreover, a 50 column width on the workbook created with
size 8 is smaller than a 50 column width on a workbook
using a default police fitted to 10.
How can I change the default police of my workbook in
order to have right columns widths.
thanks!
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---