Results 1 to 5 of 5

Thread: Retain personal views on shared workbook

  1. #1

    Retain personal views on shared workbook



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    I don't think you can have a shared workbook do that.
    Hope that helps

    Roy

  3. #3
    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.

  4. #4
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    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.
    Circumference of a circle = 2πr²



    ²the circle's radius

  5. #5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •