View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
prtcorvette prtcorvette is offline
external usenet poster
 
Posts: 2
Default password protecting cell in a protected file that are not protecte

I have an excel workbook that is a form for assigning part numbers. The form
has password protection on all cells except the ones the user wants to
fillin. I want to know if the is a way or a macro to password protect (lock
typed data in these fields) after the user fills them in and is saving and
closing the file? using excel 2003 SP2.