Hi and thanks in advance,
I'm using Excel 2003
I have a workbook which I share, if not already shared, in the Workbook Open event.
Can't seem to get it so that each user has their own view based on what they last saved. For instance, would like it to open on the sheet the user last accessed and where the panes were frozen, with columns hidden as per last session ... etc.
However, the workbook always reverts to the view that was saved by the very last user just before closing.
I'm using Excel 2003
I have a workbook which I share, if not already shared, in the Workbook Open event.
Can't seem to get it so that each user has their own view based on what they last saved. For instance, would like it to open on the sheet the user last accessed and where the panes were frozen, with columns hidden as per last session ... etc.
However, the workbook always reverts to the view that was saved by the very last user just before closing.
Code:
With ActiveWorkbook
If .MultiUserEditing = False Then
Application.DisplayAlerts = False
.KeepChangeHistory = False
.SaveAs FileName:= .FullName, AccessMode:=xlShared
Application.DisplayAlerts = True
End If
End With