LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Highlight Track Changes with VBA Code?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you have the cells highlight changes? (no track changes) bevsweets Excel Worksheet Functions 1 March 21st 08 05:29 PM
highlight row/column to track current cell ... and more! prupp New Users to Excel 3 February 11th 08 07:25 PM
Should be able to color code or highlight Excel worksheet tabs. brie_01 Excel Worksheet Functions 3 August 17th 06 03:42 PM
Auto Highlight Code joelbeveridge Excel Discussion (Misc queries) 2 August 4th 06 02:11 AM
In code be able to turn on/off Track Changes feature? John[_62_] Excel Programming 1 October 16th 03 04:17 AM


All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"