View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Custom sheet protection

Select the cells where you want to allow entry and right click on them,
Format=Cells, choose protection and uncheck locked.

All other cells should be locked (default)

No do Tools=Protect=Worksheet.

That should do what you want.

--
Regards,
Tom Ogilvy

"matrix" wrote in message
...
I want users to be able to enter data into cells, but not delete or insert

rows or columns.

I can't seem to get sheet protection to work right. Which options do I

select, or is this not possible?