"StargateFanFromWork" wrote in message
...

"Roger Govier" wrote in message
...
Hi

Thanks for the feedback letting us know how you got on.
Well done for figuring out the cause of the problem, and solving it
yourself.

<wry grin Turns out I'm still not so smart, though <sigh.

[snip]

Yet it's a toss-up. Do I leave the filtering and have an open,
corruptible environment ... or do I remove the filtering, leave all the
unprotect/protect codes in places before and after sorts but the user
can't filter at any of the columns at all. Tough, tough choice. [snip]

Had to pass along conclusions in case anyone else finds themselves in a
similar situation. I'm going to leave the ability to manually filter off.
I've again removed all the filtering code that caused the flickers in the
sheet upon opening. This was after trying the workbook again just now and
finding that even though the manual filters don't work at all, the ones in
the printing buttons do. They allow the sheet to be printed out 3 different
ways, one with all the entries, one with in-house training and another with
training done via outside sources. That's good enough, I believe, since
with fiscal year end there isn't much more I can do not having all the
knowledge needed to make such a complex thing work from all angles. If they
need anything more than that, I'll leave it to them to figure it out.

I will be paying attention to any posts in the archives again re filtering
protected sheets to see if I can learn anything more soon but in the
meantime at least we have the ability for those 3 reports above and that's
good. Since those are possible to do, it's more important now to leave the
protection codes** in place to keep
the book from being easily messed up.

(** I mean by that these 2 codes put at beginning and end of each various
commandbar macros to enable sorting, etc.:
ActiveSheet.Unprotect 'place at the beginning of the code
ActiveSheet.Protect ' place at end of code)

Thanks. All this helped. One learns so much this way even though it is a
tad frustrating. :oD