Forum Discussion
Restricting Excel File "Save As" Feature
Is there a way to limit the number of times an Excel file can be "Saved As"? With VBA? I don't want to keep the Saved As feature from working at all, just limit it to work twice for any particular u...
OK Whys1
Thanks for the explanation, now am I entitled for a free copy just to see your handy work? 😉
Then I would suggest looking into making your workbook an Add-In look here:
https://support.microsoft.com/en-us/office/save-a-workbook-in-another-file-format-6a16c862-4a36-48f9-a300-c2ca0065286e
https://www.contextures.com/exceladdins.html.
Also the you can use the aforementioned event to pop up a message stating your wishes for them not to use the workbook in a way that would infringe on you, possibly send an email to you every time the client does make a new copy. That might be a bit intrusive so seek legal advice. Also you can make the event save a copy and delete all others. I mean there are many ways to do what you want, just how strict you want to be is the ultimate question.
Thanks for the explanation, now am I entitled for a free copy just to see your handy work? 😉
Then I would suggest looking into making your workbook an Add-In look here:
https://support.microsoft.com/en-us/office/save-a-workbook-in-another-file-format-6a16c862-4a36-48f9-a300-c2ca0065286e
https://www.contextures.com/exceladdins.html.
Also the you can use the aforementioned event to pop up a message stating your wishes for them not to use the workbook in a way that would infringe on you, possibly send an email to you every time the client does make a new copy. That might be a bit intrusive so seek legal advice. Also you can make the event save a copy and delete all others. I mean there are many ways to do what you want, just how strict you want to be is the ultimate question.
If you can solve this problem, you are welcome to a copy!
Stating wishes does not work as I have been told that "if I buy it I can do what I want!"
Saving in another format will disable macros in the file, preventing further entries/changes.
I can make a macro button that will save/export as pdf (or other file type) but then the file cannot be changed, defeating the purpose of having a working copy. Your original suggestion, I believe, limits the times the file can be saved, but not "saved as". I fear that I am asking to do something that is not capable of being implemented. Appreciate your replies!
Stating wishes does not work as I have been told that "if I buy it I can do what I want!"
Saving in another format will disable macros in the file, preventing further entries/changes.
I can make a macro button that will save/export as pdf (or other file type) but then the file cannot be changed, defeating the purpose of having a working copy. Your original suggestion, I believe, limits the times the file can be saved, but not "saved as". I fear that I am asking to do something that is not capable of being implemented. Appreciate your replies!