Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Listchangesonnewsheet (excel 2000)

    Hi all, I'm trying to add this bit of code here to keep track changes,
    I keep getting the error 1004, object not set....Is there a way to accomplish this task programmically?
    I don't know what I am missing...
    Thanks Darryl.
    Option Explicit
    Public Sub ListChanges()
    Dim wb As Workbook
    Set wb = ActiveWorkbook
    With wb
    .HighlightChangesOptions _
    When:=xlAllChanges, _
    Who:="Everyone"
    .ListChangesOnNewSheet = True

    End With
    End Sub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listchangesonnewsheet (excel 2000)

    After creating the macro, you must share the workbook before running it:

    - Switch back to Excel.
    - Select Tools | Share Workbook...
    - Tick the "Allow changes by more than one user..." check box.
    - Click OK.
    - You'll be warned that the workbook will be saved. Click OK.
    - You'll be warned that the workbook contains macros, and that these cannot be edited or viewed in a shared workbook.
    - Click OK.
    - Run the macro. No history of changes yet.
    - Edit some cells, then save the workbook.
    - Run the macro again to see its effect.

    If you need to edit the macro, you will have to unshare the workbook. This will erase the history of changes.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Listchangesonnewsheet (excel 2000)

    Thank you Hans.

Posting Permissions

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