View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ChadF ChadF is offline
external usenet poster
 
Posts: 44
Default Workbook HighlightChangeOption ???

I have a piece of code that barfs on the following set of lines

Workbooks(WorkingFileName).Unprotect
Workbooks(WorkingFileName).KeepChangeHistory = True
Workbooks(WorkingFileName).HighlightChangesOnScree n = True
Workbooks(WorkingFileName).Protect

What I want to do is set the HighlightChangesOnScreen flag to True
for this particular workbook on the fly. (Not during a regular session, want
to put this in a macro.)

Originally thought that unprotecting the workbook would work, but VBA still
barfs on setting that flag. How can I get around this ??

Thanks in advance,
ChadF