View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Piers 2k Piers 2k is offline
external usenet poster
 
Posts: 11
Default 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