Worksheet change event to force recalculation

Hi

I am looking for some code to put in a worksheet module which forces the workbook to recalculate whenever the user hides or unhides a column in that worksheet.

The act of hiding or unhiding would not be triggered by any VBA routine. The user would simply select the columns with the mouse, right-click and choose hide or unhide as desired.

Thanks for any help.

I'm afraid altering Column visibility is not a Volatile action - ie it does not invoke any event (action can not be trapped by "standard" means).
This was covered in the thread I linked to in your SUBTOTAL thread.

edit: removed edit - not a viable approach...