Column widths - locking down

[Guest]

I have developed a great sheet with 4 separate SQL queries to give users a
report card.

All works wonderfully except that each time the sheet auto-refreshes, my
column widths compress down which makes the sheet hard to read.

Is there a way to lock down the colum width so it doesn't change?

Thanks

 

[Nick Hodge]

Art

You could try un-checking 'adjust column widths' in 'Data range properties'
by right-clicking on the external data table. You could also, if this
fails, put some code in the Worksheet_Change() event like so

Private Sub Worksheet_Change(ByVal Target As Range)
Columns.AutoFit
End Sub

This way any entry in the worksheet that contains the code will autofit the
data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)