Prohibit excel file sharing

[emc123]

I have created an excel file that is used by multiple users, contains macros and is NOT shared. The file has been protected (worksheets, workbook & VBA) to ensure the integrity of the file/macros.

How do I prevent a user from turning the file into a protected/shared workbook to ensure that the macros continue to function?

The ability to unprotect/protect a worksheet/book is also disabled once a protected/shared workbook is created.

Thank you for help,

Erik

 

[shg]

I think no one can prevent a workbook from being shared. Shared workbooks are more likely to become corrupt (some would say inevitable), but macros should still work.