Retain personal views on shared workbook

D

deutz

New member
Joined
May 28, 2012
Messages
27
Reaction score
0
Points
0
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.

Code: 
With ActiveWorkbook
   If .MultiUserEditing = False Then
        Application.DisplayAlerts = False
        .KeepChangeHistory = False
        .SaveAs FileName:= .FullName, AccessMode:=xlShared
        Application.DisplayAlerts = True
    End If
End With
 
Hi royUk,

I'm pretty sure that I did some work with a shared workbook sometime in the distant past where my view got saved each time. But, perhaps you are right and I'm losing the plot.
 
That is how shared workbooks are supposed to work, as far as I know (well, in so far as Shared Workbooks work at all), but the fact that you need to share the workbook in its open event would suggest that you're losing the views when it is not saved as shared.
 
Thanks JoePublic and royUK,

Looks like I was labouring under a misconception then.

I only share in Workbook Open if for some reason the workbook becomes unshared which probably wouldn't happen very often.

Regards
deutz
 
You must log in or register to reply here.
Back
Top