View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CharlieS CharlieS is offline
external usenet poster
 
Posts: 7
Default Protecting Cetain Cells in Excel

I have a spreadsheet that we will be sending out to many users. It will have
several columns protected and one unprotected so that the users can enter a
Yes or no to that column. I want to know if I can have that cell protected
once the entry is made or do I need to go back and lock that cell
individually? I have 44,000 rows we will be working with and it could get
very tedious to have to relock each one at the end of the day... HELP!