Visharathi
10-18-2016, 03:32 AM
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
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