The disadvantage of that strategy is that users need the template with them when they work on a laptop on road and moreover they can overwrite each others files. Is there a way with VBA to create an .exe file that doesn’t interfere with other copies?
Any resolution to this?
I have encountered the same problem.
SaveSecureWorkbookToFile works fine but when I recompile with ‘Allow save but do not handle loading/saving’ nothing happens.
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...
I mean that .xlsc file can only be opened through the XLSPadLock secured file (.exe) which is the template in my application. Can I clone a secured .exe file through vba in any way?
I have an application that consists of a (organisational) template that can be initialised by a user and then becomes a personalised copy of the template. (Using SaveAs which leaves the template as original to use for the next user and saves the initialed version with a new name for use by that...