Dobbin0_4,
You can add macros and buttons to your sheet to hide/show all the data on
your sheet, until you need to edit it, such as:

Macro#1:

Sub HideRows()
'
   Range("A6:G100").Select
   Selection.EntireRow.Hidden = True
   Range("A1").Select

End Sub

Macro#2:

Sub ShowRows()
'
   Range("A6:G100").Select
   Selection.EntireRow.Hidden = False
   Range("A1").Select
End Sub

Or just hide the column:

Macro#3:

Sub HideColumn()

Columns("G:G").Select
   Selection.EntireColumn.Hidden = True
   Range("A1").Select
End Sub

Macro#4:

Sub ShowColumn()
'
   Columns("G:G").Select
   Selection.EntireColumn.Hidden = False
   Range("A1").Select
End Sub

You need to adjust the Range information to fit you needs. I am new at
macros, so I had to create to of them. Some one more experienced with them
should be able to, show you how to combine the hide/show macro, so a single
button can be used, to either hide/show rows or columns.

Ok so I got the formula you gave me working.  But there is a small problem i
am trying to use data from the cell above in my formula. so it looks like
this:

=c1-b2+a2

working with the formula you suggested is ok till i add "c1" to the formula
like the example below:

=IF(OR((A1="0"),(B1="0")),"",C1-A1+B1)

Because the data in cell c1 is copied down and i am back to where i started!

anyone else who can help with this.  I would be grateful or if Gary Student
has any other ideas , again thanks

"Gary''s Student" wrote:

Use the same approach:
=IF(OR((A2="0"),(B2="0"),(A2=""),(B2=""),(C1="0"),(C1="")),"",C1-A2+B2)

The key is to test ALL of the values that you need.  If ANY are zero or
missing, then return blank