What version of Excel are you using?

I have built workbooks with Macros that have been shared.

You need to remove the Share option for the workbook.
Build your macro
Share Workbook