I am sorry I can’t get my point across.
I have an application that consists of a template (.xlsm) for Organisational use by several users.
When this template is opened the user can enter their details en click a Setup button.
When clicked the details of the user are used to rename the template and main sheets are enabled.
From then on this copy is used as personal working copy of this user.
I use VBA’s SaveAs command; this renames the template and leaves the template as original for use by the next user to setup its personal copy.
I am after a way to replicate this behaviour with a secured file.
When I compile the the template and provide the license key to the clients administrator I would like that the template (.exe) can be setup by the client’s users as above. How can I arrange that a user can open the template, enter some details and then activate my setup code with a button that arranges a (personalised) copy of the template as .exe file with the changes made and leaves the template as original. From then on I would like that the usercopy (.exe) automatically and saves changes automatically without prompt. All users should be able to work with their own copy without any interference or options to overwrite each others changes.