'把下面的代码写入ThisWorkbook对象里 Public c AsInteger'上次列号 Public w AsSingle'上次列宽
PrivateSub Workbook_SheetSelectionChange(ByVal Sh AsObject, ByVal Target As Range) With Sh If Target.Count = 1 Then If c > 0 Then .Columns(c).ColumnWidth = w EndIf w = Target.ColumnWidth c = Target.Column Target.ColumnWidth = 20 '20表示扩大的宽度,自行修改 EndIf EndWith EndSub