Thread: Lock cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Lock cell

Hi
first select all cells you want to unlock. Goto 'Format - Cells -
Protection' and uncheck 'Locked'. After this protect your sheet
('Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany


Mohamed wrote:
How to lock a cell which contains a formula