View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ebbe[_2_] Ebbe[_2_] is offline
external usenet poster
 
Posts: 9
Default Overview over lockd cells in a sheet.

Hi

I am working with a sheet in witch som registration is entered and then some
formels ar calculating on the entered data.

My concern is that I have unprotected cells, that should be protected and
protected cells, that should be unprotected

Is it possible to highligt all protected/unprotected cells in a sheet?
The formel control function varns me if a cell with a formel is not
protected (locked).
But blank cells and cells with prompt text can be unprotected without
varnings.

Ebbe