View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default How do I protect a Work sheet so a user can only alter certain cel

Joel,

First you select all cells that you want to allow changes.
Format|Cells|Protection, set the Locked option to false.

Then Tools|ProtectionProtect Sheet

HTH
Kostis Vezerides


Joel wrote:
Hi I have created a workksheet that is to be used as a form when I eventually
save it as a template. There is only certains cells which I would like them
to be able to change.

How do I go about this

REgards Joel
--
N/A