I assume you've started down the VBA path from your other post. I personally would train the users to create their own personal views with their own table settings.

You can only go so far with trying to capture everything a user can or will do. A little training can go a long way