Error: VB Code for "ThisWorkbook" Mac version

[YesConsulting]

I wanted to extend the functionality of the doubleClick to all the sheets in a workbook, rather than having duplicating code in multiple worksheets.

1 So clicked on "ThisWorkbook" in VBA Project manager.
2 Got a Code Window.
3 Clicked on "Workbook" from the dropdown ((General)
4 Got an error
"Variable uses an Automation type not supported in Visual Basic


I am running v16.16.5 on a Mac OSX version 10.14 (latest)

Is my thinking correct? I was going to use the Sub "SheetBeforeDoubleClick" to do the work.

 

[steve the fish]

Looks like a problem with the mac. The syntax is:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

End Sub

Try that and see how you get on.