none
Issue: "Variable uses an Automation type not supported in Visual Basic" RRS feed

  • Question

  • Hello,

    In order to keep the hyperlinks active when hiding the other worksheets I'm trying in VBA to switch from "(General)" to "Worksheet" and then to change into "Follow hyperlink" in the section Selection change. But no matter which sheet in the VBA Project I picked, any time I try to select "Worksheet" the following message pops out : "Variable uses an Automation type not supported in Visual Basic".

    Can anyone help me with that?

    FYI I'm using a MacBook Pro.

    Friday, November 29, 2019 12:44 PM