Interference with Personal Macro Workbook macros and other workbook macro(s)

Just got a new job and lots of Excel stuff to work on. I hope that this forum can help. I can mostly figure things out myself, but not my current dilemma. So I'll be posting my specific problem(s) elsewhere, as the rules here seem to state that I shouldn't ask my initial question here.

I'm a novice to advanced user of Excel; the rank would depend on which part of Excel is being discussed. For instance, I am an absolute novice (no experience whatsoever) at Pivot Tables (I know they exist!) but would consider myself intermediate to advanced at making User Forms (and the code behind them).