Hello,

I would like to integrate in my worksheet a button that executes Track
Changes -- HighLight changes. To avoid that users have to use the
menu entries.

I recorded a macro and got the following code:

With ActiveWorkbook
..HighlightChangesOptions When:=xlAllChanges, Who:="Everyone", Whe=
_
"1:65536"
..ListChangesOnNewSheet = False
..HighlightChangesOnScreen = True
End With

However, when linking this code to a action buttion. I always get the
following error message: "HighlightChangesOptions doesn't exist for
object _Workbook"

Can anyone help to get it working`? What is wrong?

Thanks & Happy Holidays.

Don't know if this is related to your problem or not, but
You have to share the workbook to invoke Track Changes. Is the workbook
shared?

--
Regards,
Tom Ogilvy

"Garp" wrote in message
om...
Hello,

I would like to integrate in my worksheet a button that executes Track
Changes -- HighLight changes. To avoid that users have to use the
menu entries.

I recorded a macro and got the following code:

With ActiveWorkbook
.HighlightChangesOptions When:=xlAllChanges, Who:="Everyone", Whe=
_
"1:65536"
.ListChangesOnNewSheet = False
.HighlightChangesOnScreen = True
End With

However, when linking this code to a action buttion. I always get the
following error message: "HighlightChangesOptions doesn't exist for
object _Workbook"

Can anyone help to get it working`? What is wrong?

Thanks & Happy Holidays.