In a large workbook with a number of worksheets, some worksheets have certain
columns hidden or grouped and normally viewed at level 1. Also, some
worksheets have code that runs on sheet activation and/or de-activation, and
if I move from one of those to a worksheet containing the grouping it is
ungrouped, whereas moving to it from other worksheets doesn't cause the
problem and it remains as saved. Any ideas please?

Also, can someone please explain the difference (if there is any) between
Activate/De-Activate and Open/Close when writing code related to Events.
--
pignick