View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Halim Halim is offline
external usenet poster
 
Posts: 182
Default Block Manual Entry

Hassan,

Try to use protection menu:
1. Select Cells by clicking upper left border of a sheet
2. choose format cells menuProtection then Uncheck Loked checkbox
3. then select G1:H1
4. choose format cells menuProtection then Check Loked checkbox
5.Then protect your sheet.

--
Regards,

Halim



"Hassan" wrote:

Hi All,

I have a spreadsheet that has 5 coloumns, where 3 I have to put data and I
applied the formula on other two i.e. g1 & h1, is it possible to restrict g1
& h1 on manual entry?

Regards