I already have the display alerts as false at the start.
Regarding DoCmd, thats probably right. I was using it to prevent an append query error msg from showing up.
The issue I'm trying to get here is there is some code that was written in Excel2003, but some users are still on 2000. The crux of the program works, except for 1 piece and I'd rather the code not pop up all kinds of errors when it gets to that point.
It protects a specific range from data changes/columns deletion but allows for formatting. This feature isn't available in 2000. I didn't realize until this morning that some people were still on old versions which is wy this hadn't come up.