最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Disable File send to email in Excel with VBA - Stack Overflow

programmeradmin3浏览0评论

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?

发布评论

评论列表(0)

  1. 暂无评论