I am using the following code for several different tables in one workbook:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("Table2").RowHeight = 15
Selection.Rows.AutoFit
End Sub
Some of my colleagues love this feature but others find it annoying, so I would like to provide toggle buttons that enable and disable the macro a particular table. Can someone provide the code to implement this with a button that either
(1) references the macro above or
(2) incorporates that functionality, replacing the macro above?
Also, which button or other control would be most suitable?
Bookmarks