EXCEL VBA: Compile error in hidden module only on MacOS

Question

I have a problem with running a VBA in a Excel spreadsheet on a MacOS (Sierra). On Windows everything works like expected. I always get the "Compile error in hidden module: Interpolation ...

I tried to remove the whole content of the module and this is the leftover:

Function interpolate(x As Double, ran As Range) As String

interpolate1 = 1
interpolate = interpolate1

End Function

The VBA code is password protected and I don't use any ActiveX controls. The references I use are as follows:

Visual Basic For Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library
RefEdit Control

If anyone has any suggestions on how to go about this problem, that would be great.

Thanks, Tro

Got it, RefEdit is missing on MacOS.

tro
– tro

2017-01-04 17:18:01 +00:00
Commented Jan 4, 2017 at 17:18 — tro
– tro, Commented Jan 4, 2017 at 17:18

tro · Accepted Answer · 2017-01-04 17:21:40Z

1

The RefEdit reference was missing on MacOS. I removed it and now it seems to work.

answered Jan 4, 2017 at 17:21

tro

9442 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

EXCEL VBA: Compile error in hidden module only on MacOS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related