View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
enna49 enna49 is offline
external usenet poster
 
Posts: 54
Default Macro Button or Auto Protect Formula

Is there anyway I can protect only cells that have data. eg after
entering data for a number of lines I would like to protect only the cells
that have data in one step.

Therefore when the worksheet is opened again the user can continue to enter
data and in one step protect what has been done.
Thanks
AR