VBA Allow only "Save As" function

[az!]

Hello,

I am working on a file that will be sent to many people. Those receiving the file should only be able to save the file using the "Save As" option, so that my file does not get changed. However, when I make changes, or another user I specify, we should be able to use the "Save" option.

In other words, Jack, Bill and Mary should be able to use the "Save" option and all others only be able to use the "Save As" option.

How can I do this?

Thank you in advance for your help!

Sincerely,
az!

[shg]

Why not just have them mark the file as read-only? Or send them a template (xltx or xltm) instead of a workbook?

[az!]

Thank you! I also found out I can add a password to open and a password to modify a document. That way the people who are allowed to modify the document will have the password.

~az!