Sharing Excel Workbook With a Table

[nparsons75]

Excel will not let me share a workbook with a table that has been created. To share it I need to convert the table to a range, this reduced the functionality of my worksheet. I have to share the workbook so that I can track changes. I need to see a history of various values that have been changed and by who?

Is there any workaround for this? I need the table so that I can filter various rows?

Thanks,

 

[RoryA]

You'd need to use code to log the changes to the workbook instead of sharing it.

 

[nparsons75]

Ok thanks, any idea of where i could find such code, im a novice with vba...

 

[RoryA]

Here?

For example: https://www.mrexcel.com/forum/excel-questions/500810-vba-code-track-changes-workbook.html