Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a cell be turned on or off?
A1=B1*C1+D1
A2=B2*C2+D2 A3=B3*C3+D3 A4=B4*B4+B4 I would like to be able the have the total in any one of the A cells to add up only if the cell is click on. In other words, can a cell be turned off or on as needed? -- Joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a cell be turned on or off?
Right click sheet tabview codeinsert this
Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, Cancel As Boolean) If Target.Column < 1 Then Exit Sub 'B1*C1+D1 tr = Target.Row Target.Value = Cells(tr, 2) * _ (Cells(tr, 3) + Cells(tr, 4)) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "painter50" wrote in message ... A1=B1*C1+D1 A2=B2*C2+D2 A3=B3*C3+D3 A4=B4*B4+B4 I would like to be able the have the total in any one of the A cells to add up only if the cell is click on. In other words, can a cell be turned off or on as needed? -- Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't want a (C) in a cell and it turned to a copyright symbol | Excel Discussion (Misc queries) | |||
Can a cell be turned on and off? | Excel Discussion (Misc queries) | |||
can you format a cell so that formulas will be turned off | Excel Discussion (Misc queries) | |||
How can I edit cell notes while track changes is turned on? | Excel Worksheet Functions | |||
Why am I getting XXX error in text cell with word wrap turned on? | Excel Discussion (Misc queries) |