Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Hidden fields
Message
 
À
08/08/2002 06:12:08
Debbie Galura
Deltek Systems Philippines
Makati, Philippines
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Divers
Thread ID:
00687427
Message ID:
00687556
Vues:
8
>Is it possible for Excel not to include "hidden" fields in any computation I have in my worksheet?

This isn't real pretty, but this is the only way I could see how to do it.
You could lock the cells as well and use the Cell function and see if the protect value is 1 for locked.

For example, let's say cell A1 is locked (and hidden). You could have a formula that you didn't want effected by hidden cells by making the formula something like: =IF(CELL("protect",A1)=1,A1+B1,B1)
___________________________
Kenneth Wonderley
http://www.wonderley.com


...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform