View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default Workbook Highlighting property

Hi Chad,
I have not worked much with Shared workbooks so please excuse me if I am off
the mark here.
I think you have to Share the workbook first.
Thanks.

"ChadF" wrote:

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