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

I have a piece of code that barfs on the following:


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

Workbooks(WorkingFileName).Protect

This set is at the bottom of a rather large macro in my application.

Trying to set the HighlightChangesOnScreen flag to True on the fly.

Originally thought that wrapping that statement between a
Workbook Protect/Unprotect would do the trick, but apparantly there's more
to it than that.

Any suggestions ??

Thanks,
Chad