I just "discovered" this by accident a few weeks ago.
Have LOTS of application for it - but having problems setting it up.

Situation:
Have Five Groups.
The First Line of Each Group will have the "trigger" in Cell E?
Each Group has range name for complete group.

If group 1 selected, the "undo" instructions of group 2 seem to void what
the original selection was trying to do.
Is there a way to get around this?

If Range("FBSMINT") 0 Then ' "trigger" cell
Call FLBIN_SMI_H ' This hides the group 2, 3, 4,
and 5 ranges
Else
If Range("FBSMINT") = 0 Then ' "trigger" cell, again
Call FLBIN_SMI_UH 'This Unhides the group 2, 3, 4
and 5 Ranges
End If
End If

If Range("FBSAINT") 0 Then
Call FLBIN_SAI_H ' This hides group 1, 3, 4 and
5 ranges
Else
If Range("FBSAINT") = 0 Then
Call FLBIN_SAI_UH ' This Unhides group 1, 3, 4 and
5 Ranges
End If
End If

Therefore, If group 1 is selected, the Unhide instructions in group 2 undo,
what group 1 is trying to do. However, I do need some whay of "unhiding" in
case of a mistake or change of mind.

End Result : As various selections are made within the various groupings on
the contract templates, the template will shorten considerably, making it
much easier to view and work with, by the salesmen.

I hope my attempted explanations are not too convoluted.
As you can see, I have no problem utilizing standard modules together with
the worksheet module - I think it actually helps keep things clearer.

I sure hope someone can help me with this. I'm very excited about what I see
as the possibilities for this application.