Hello all,

I'm using excel 2016 in mac. I've created a macro which reads some data from an another excel file and do some math after closing a input file. My xlsm file is works fine in earlier versions of Mac excel, but in 2016 scrollarea property and workbook.close is not working. I tried to lock my sheet in workbook open. Following is the code used

To scrollarea:

Private Sub Workbook_Open()
Sheets("sheet1").ScrollArea = Range("A1:T50").address
End Sub
To close:

#if mac then

workbook("filename.xlsx").close false

#end if

Please anyone help me to solve this!!!

Thanks in Advance