Okay, so now I feel like an idiot. It does Protect the sheets! But,
with a twist.

Remember I said Sheet1 starts off Protected while the others didn't?
Well, when I manually Protect a sheet, I uncheck everything except the
'select unlocked cells' option. So, when I was checking the other
sheets after the Sub ran, it allowed me to select any of the locked
cells as well, and this threw me off. See, I never tried to actually
CHANGE any of the values in the (locked) cells. I was just selecting
the cells and thought the sheet wasn't locked in the first place. What
I was forgetting was to set the .EnableSelection method to
xlUnlockedCells prior to Protecting the sheet.

However, this does bring up a question: why would it Protect Sheet1
based on how it was previously Protected, while it only locks the
others with the default settings? Is that just a feature of the
program, by relocking with whatever options were enabled at first?

Thanks to everyone who tried to help and take the time to try to solve
the problem. At least now it's behaving as expected.


--
AMK4
------------------------------------------------------------------------
AMK4's Profile: http://www.excelforum.com/member.php...o&userid=19143
View this thread: http://www.excelforum.com/showthread...hreadid=501872