I switch it FALSE for the procedure for clearing the calendar -- otherwise it clears my formulas and everything.

Then I switch it back to TRUE at the end of the clearing macro. At least I think that's what I'm doing -- I know before I added that, I was wiping out everything with this macro.