code to toggle (enable/disable) a specific Worksheet_SelectionChange macro

You've attached that macro to a sheet Selection change event which means it will run whenever any cell is selected.

Are the tables on different sheets? If so one option might be to use an Forms Control Checkbox somewhere which sets the value of the linked cell to True or False. Name the linked cell say SetRowHeight

Then test the cell value with an IF test as the first line of your macro

e.g.
If Range("SetRowHeight") = False Then Exit Sub

You could use a Workbook Sheet Change event instead of a Sheet Selection Change. This would avoid the need for a macro on every sheet although it will only run when a cell value is changed, or at least selected and re-entered, unlike the Sheet Selection change vent which runs whenever a cell is selected

If that macro is the only event macro in your workbook, you can disable and enable events using a macro for each task. Place these two macros in regular modules. Assign a button to each macro. The first macro will allow your event macro to run. The second macro will disable it.

Please Login or Register  to view this content.