How about double-clicking a cell to add or remove a tick-mark?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Const WS_RANGE As String = "H1:H10" '<=== change to suit

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If .Value = "a" Then
.Value = ""
Else
.Value = "a"
End If
.Font.Name = "Marlett"
End With
End If

End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"d smith" wrote in message
...
I found this macro set on the internet. It is old, and points the code to
the wrong files, etc. I was able to fix that issue, so that I could use
it
temporarily. It is not a perfect answer, but it works. I would rather be
inserting a number/figure/ etc. that pasting a picture. The pictures
realy
don't print in black and white very well.

http://www.cbi.msstate.edu/cobi/sac/tickmarks.html


"Bob Phillips" wrote:

Can you give a bit more detail on what you want, a toolbar button that
adds
a tickmark to the activecell, a tickmark alongside the menu item, a tick
toolbar button, et al?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"d smith" <d wrote in message
...
I have been told that I can add a tickmark toolbar to excel.