VBA Track changes on shared workbook

[Michiko]

Hello Everyone,

I have a VBA that copies a given sheet from my workbook.xlsm to a new workbook.xlsx and saves it in a shared folder. It works just fine, but I want it to enable track changes on the new workbook.xlsx before closing it.

Since I'm not an expert on code, nor whatsoever!, I've just searched for the piece of code online. However, I've already tried a lot of combinations and none worked, I always get an error. Currently, I'm using this:

With ActiveWorkbook
  .HighlightChangesOptions _
  When:=xlAllChanges, _
  Who:="Everyone"
  .ListChangesOnNewSheet = False
  .HighlightChangesOnScreen = True
End With

And getting this:

(Yes... The code gets highlighted... Just not the kind of highlight I want ?)

Can anyone help, please?

Thanks!

 

[GWteB]

Weird that it doesn't work for you. Just created a net share in a virtual machine and it works as expected for me.
What happens if you just save the workbook first, and then save it again as a shared workbook, as in:

     With wbNew
         .SaveAs FileName:=NEWFILE, FileFormat:=xlOpenXMLWorkbook

         .SaveAs FileName:=wbNew.FullName, FileFormat:=xlOpenXMLWorkbook, AccessMode:=xlShared

 

[Michiko]

I figured out what was happening: the worksheet had a table. A TABLE!

Converted to range... Boom!

It doesn't matter the specific code I use: all of them work.

Anyway: thank you very much for all your help!

 

[GWteB]

You are welcome!

I figured out what was happening: the worksheet had a table. A TABLE!

I really wouldn't have thought of that.
Great news, well done and thanks for letting us know, so that others can benefit from it.