Vba Code

[Junaid7861]

Hi,
Please help mein this.

I have invoice format of 50 sheets these codes apply of worksheets

Vba Code
can row height & column width fixed that not drag from mouse or tool bar.
fonts Tahoma size 11 (A23:H29)
THEN THIS FORMULA IT WORKS PERFECT
ws.Columns("A").ColumnWidth = 11
ws.Columns("B").ColumnWidth = 20
ws.Columns("C").ColumnWidth = 8.71
ws.Columns("D").ColumnWidth = 5
ws.Columns("E").ColumnWidth = 5.29
ws.Columns("F").ColumnWidth = 11.43
ws.Columns("G").ColumnWidth = 10.43
ws.Columns("H").ColumnWidth = 16.57

' Set the row height for rows 23 to 42
ws.Rows("23:42").RowHeight = 22.5



FROM : JC