adding a check box 3 (mac)

[Peter McCaul]

Thanks to the people who responded to adding a check box 2 (mac).

I inquired about turning a cell into a check box. When you move the cursor over the cell, you can click on it and a check will appear. In my earlier post, the response I got was the code below. It works like a charm on a PC. When I try it on a Mac, nothing. On the Mac, I couldn't find a view code function so I opened up the Visual Basic program and inserted the code into worksheet one. It didn't work.

The code reads like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
Target.Font.Name = "Marlett"
If Target = vbNullString Then
Target = "a"
Else
Target = vbNullString
End If
End If
End Sub

Any help is appreciated, thanks.

 

[Dave Peterson]

I don't use a Mac so this is just something for you to verify.

Are you sure you put the code behind the worksheet that you wanted?

I like to rightclick on the worksheet tab and select View|code and paste there.

 

[Peter McCaul]

Unfortunately, you can't right click in the Mac environment. The mouse only
has one click. Thanks anyways.

 

[Debra Dalgleish]

On a Mac, you can Ctrl+click on the worksheet tab, then choose View Code.

Also, there's a Mac Excel newsgroup, where you might get some help with
Mac issues:

microsoft.public.mac.office.excel

Unfortunately, you can't right click in the Mac environment. The mouse only
has one click. Thanks anyways.