I have a file that I want to protect from excessive distribution.
To do this, I have locked several cells before editing. These cells are unlocked by a macro that checks if the username matches. If the file is opened by a verified user, the cells are unlocked and the tool can be used
The file in this state (unlocked cells) could be saved to disk and copied to other people. To do this, I have disabled the "Save as" button
Unfortunately, it turns out that the unlocked file can be sent by sharing as an email attachment.
I have been trying to find a solution for a long time, so that the file share via email button is inactive.
Is it possible to block this function via vba?