Column Row question

[Henry]

Can you lock the Column Width and Row Height for non-adajcent areas.

I don't want Col A, F, and Z to change. Same with row 3,4,5,8.

Thanks

 

[Derek]

Hi there

You could use an event macro perhaps:

Right click you sheet tab, left click View Code and paste in this code:


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A:A,F:F,Z:Z").ColumnWidth = 10
Range("3:3,4:4,5:5,8:8").RowHeight = 22.5
End Sub

Not the best answer but it will work

Regards
Derek

 

[Henry]

Hi:

Thanks. Does this allow me to set ColA at one width and and Col C at another, and Col L at another?

MT

 

[Derek]

If you want each column a different width you would have to change the code to reflect that, eg

Range("A:A").ColumnWidth = 10
Range("F:F").ColumnWidth = 15

etc etc

regards
Derek

 

[Henry]

Thanks Derek--I'll try it.

 

[Henry]

Derek:

I inserted the code exactly as you provided and saved the .xls. But,when I go back to the .xls, I can still manually change the Column widths, which is what I don't want to do. If I can do it, the customer can also do it.

Suggestions!