Column Measurement Defaults

[gary_marshall]

Can I change the default measurements for the columns to something else (inches). I am trying to fill in a form that has boxes, check off boxes, etc. and it would be easier if the column width defaults could be set to inches.

Thanks in advance for your advice.

Gary Marshall

 

[shajueasow]

Hi marshall,
Use this in your required excel workbook, in the Workbook_Open event. It will get you almost to one inch cells........!

Private Sub Workbook_Open()
With Cells
.ColumnWidth = 13.3
End With
End Sub