Mac 再要你命3000[office2007].xlsm 无法使用宏

[kennedy-han]

使用宏时报错：Compile Error
Syntax Error
This workbook 20:0

之后弹出一个 visual basic editor

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
 If (bAuto <> "_") Then Exit Subb

[kennedy-han]

control + alt + T 和 control + alt + O 可以用
control + alt + up | down 不可用

[F4bwDP6a6W]

如果宏报错一般是excel版本的问题。

[Maecenas]

#4
检查发现是宏中的 Declear 语句在64位系统上的适用性问题，已经检查修复，发了一个 Pull request。

from
Private Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long
to
Private Declare PtrSafe Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As LongPtr) As LongPtr

References:
https://msdn.microsoft.com/en-us/library/office/ee691831%28v=office.14%29.aspx?f=255&MSPPError=-2147217396