Highlight Track Changes with VBA Code?

G

Garp

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", Where:=
_
"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.
 
T

Tom Ogilvy

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top