I have been told that I can add a tickmark toolbar to excel.

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.

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

"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.

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.

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.