looking for auditor tickmarks to add to excel toolbar

B

Bob Phillips

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

d smith

It would look like a standard toolbar with button with "Pictures" of items
that would represent standard auditor tickmarks such as: GL, TB, traced to,
vouched to, etc. I could insert an extra column on my work papers and insert
the appropriate tickmark from the toolbar to represent the work done on the
particular data next to the tickmark
 
D

d smith

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
 
B

Bob Phillips

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)
 
Top