In the larger spreadsheet, even if I separate it into two buttons and don't even use an IF statement, only the first of the paired statements gets executed:
Sub OptionButton2_Click()
Set MyColumns = Worksheets("My Worksheet Name").Range("My Range").Columns
MyColumns.Hidden = False
MyColumns.WrapText = True
End Sub
Sub OptionButton3_Click()
Set MyColumns = Worksheets("My Worksheet Name").Range("My Range").Columns
MyColumns.WrapText = False
MyColumns.Hidden = True
End Sub
The problem happens everywhere I'm trying to turn OFF text wrapping in those cells. It's like the act of turning off text wrapping is choking Excel somehow. I turn it off and there's a long pause in the script execution, and the next statement never executes. So, in the example above, it turns off the text wrap but never hides the columns.