Got it. Created Functions in one of the Modules and used Run in the Workbook_Activate/Deactive event handlers to get them to work......had to reorder some of the commands as I think some were cancelling others out.

Thank you for confirming that I was on the right track, Dave....it's amazing what can be accomplished out of desperation!