Unless it is just simply are able to unshare the workbook to view the
VBA Code.

You can do this by going to Tools _ Share Workbook, then uncheck the
box that reads "Allow changes by more than one user...", then try the
VB editor

Just an idea.

somethinglikeant