Sep 24 2022 12:02 PM
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 user. No more endless copies!
Sep 24 2022 03:36 PM
Sep 24 2022 04:01 PM
Hi @GeorgieAnne
Thanks for your response. I sell an Excel based planning tool for individuals, but lots of professional firms have been buying it and making endless free copies for clients. Not fair to paying customers. Individuals sometimes make a couple of copies to try out different scenarios, but don't need to "save as" more than twice. I want to limit the number of times the file can be "saved as" (not "saved") to prevent firms from taking advantage. It's okay for the file to be "saved" as many times as needed, just not using "saved as".
This would not be a perfect fix but should act as a deterrent.
Sep 24 2022 04:13 PM
Sep 24 2022 04:50 PM