View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AMK4[_38_] AMK4[_38_] is offline
external usenet poster
 
Posts: 1
Default Allow cell formatting only


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