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
|