Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hidden fields
Message
 
To
08/08/2002 06:12:08
Debbie Galura
Deltek Systems Philippines
Makati, Philippines
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Miscellaneous
Thread ID:
00687427
Message ID:
00687556
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform