I have a sheet containing a school year calendar on it. I want to
protect it so that they can't change the cell contents, but they can
change the cell formatting. Is there a way to do that? Or am I
looking at having to write an onChange routine that checks every time
if a value has changed and change it back?


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

Hello,

If You Use tools - Protection - Protect sheet and check only Select
Locked cells, Select unlocked cells and Format cells then the user can
only format cells. If you unlock certail cells and check select
unlocked cells only and format cells the the user can only select those
unlocked cells only even for formatting.

Thanks