PDA

View Full Version : Workbook.close and limit scroll area in Mac excel 2016



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