I have a macro that executes when users leave a sheet that locks what I'll call primary fields, clears all other unlocked secondary fields, then unlocks those locked primary fields. Works fine except for one sheet, where there's an OnActivateSheet trigger that sets and locks one of the primary fields. That trigger sets the field fine, but it doesn't lock it. This doesn't happen if I enter from a sheet that doesn't have that macro executing from an OnLeaveSheet trigger.
Any thoughts? I'm using v10.00.9282.8 SR4.