Procedure worked for a while...

[Conner]

PHV made a helpful hint that worked like a charm. I needed a "tally" procedure in excel. He proposed a solution and the solution worked UNTIL I closed out the excel spreadsheet,shut down the computer, went to lunch and then tried starting things back up again. When I did, the following procedure no longer works in the workbook sheet....Why?

Private Sub Worksheet_BeforeDoubleClick(By _
val Target As Range, Cancel As Boolean)

'Adds one to the number already present in the cell

If IsNumeric(Target.Value) Then
Target.Value=Target.Value+1
End If
End Sub

 

[tony813]

Hello Conner,
I have a silly question, but worth to ask....

When you opened the you get a message box asking
you if you wanted to Disable or Enable Macros..
And of course did you click on Enable Macros?

Also you may want to check your Macro Secuity Selection..
If its on high.. that would be the problem..

Menu: Tools/Macro/Security

tony_813