Thread: Protections
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noob Jedi Noob Jedi is offline
external usenet poster
 
Posts: 33
Default Protections

On Dec 27, 1:34*pm, tonyalt3 wrote:
I only want users to be able to enter data in a few cells of a
worksheet, how do I go about doing this?


Tools, Protection, Allow Users To Edit Ranges...

Should be self explanatory from there. When you protect the sheet,
it'll lock down all cells not included in your selected ranges.