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

Workbook HighlightChangeOption ???
 

Chad,
IIRC these only take effect on shared workbooks.

NickHK

"ChadF" ...
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

Workbook HighlightChangeOption ???
 

When you do it manually, Excel saves the file. Try saving the file after
KeepChangeHistory, and putting the file into xlShared mode.

Workbooks(WorkingFileName).KeepChangeHistory = True
Workbooks(WorkingFileName).SaveAs , , , , , , xlShared

See how that does

Piers