Lock multiple spreadsheets in one code only

Opus

Opus

New member
Hi,

I am trying to lock a total of 12 spreadsheets in one .Exe file only .
Where when they get the access by license ,they can browse them all with one license only.
I did add them in the companion files area,but it seems useful only for linking cells.
Otherwise i need to create 12 different .Exe and licenses every time,wich is wild to manage !
 
It seems you’re facing challenges with managing multiple licenses for your spreadsheets. Managing 12 separate licenses can indeed be complicated. However, there is a way to simplify this process.

Instead of creating 12 different .exe files with separate licenses, you can configure all 12 executables to share the same licensing information. By doing this, once a user activates one executable, the other 11 will recognize the activated license and function as if they have been activated as well.

To achieve this, you need to ensure that the following parameters are shared across all 12 projects:
  1. Application GUID
  2. Application Master Key
By using the same Application GUID and Master Key across all the executables, they will share the same licensing information, allowing for a single license to unlock all 12 spreadsheets.
 
Please can you kindly a step by step answer,
It can be useful then for everyone to use,as the user guide it has no citation about this ,

I’ve applied the same GUID and Main app master key from the main spreadsheet to all the other ones i want to include.
When i pack the .Exe only the main spreadsheet loads .
So i need to create an .exe for all the others too and the one license generated by the main one will work for them all right ?
 
If you don’t want to make a menu in your main workbook to open other compiled workbook files with VBA, then yes, you’ll have to make an .exe for each workbook file. Sharing the parameters as explained above.
You can also easily share parameters by using the XLS Padlock’s template functions in the menu:
image
 
Make a menu what does it mean.

A Macro that once clicked it opens the wanted spreadsheet ?
Will it be allowed by Padlock ?
Also if yes, what are the requirements.
do they need to be in the same folder ?
They have to be compiled too as .exe ?

We don’t know this software and guides are not provided for some aspects so it’s obvious that we lack on coming out with ideas in a closed environment software .

Please mate be helpful,You don’t cite any further detail to guide the user
 
Here is a tutorial:

Step 1: Set Up Your Workbook​

Before writing the macro, you need to set up your menu workbook. This workbook will contain buttons or hyperlinks that will open other workbooks when clicked.
  1. Create the Menu Workbook:
    • Open Excel and create a new workbook. Save this workbook in the same folder where the other workbooks are stored.
    • Name this workbook something like MenuWorkbook.xlsx.

Step 2: Enable the Developer Tab in Excel​

  1. Go to the File menu.
  2. Click Options, then select Customize Ribbon.
  3. Check the box next to Developer on the right-hand panel and click OK.
The Developer tab will now appear in your Excel ribbon.

Step 3: Write the Macro to Open Workbooks​

Next, you will write a macro to open the other workbooks from the menu.
  1. Go to the Developer tab, and click Visual Basic. This will open the Visual Basic for Applications (VBA) editor.
  2. In the VBA editor, click Insert > Module. This will insert a blank module where you can write your macro.
  3. Write a macro to open a specific workbook in the same folder. Use the following code as an example:
Code: 
Sub OpenWorkbook1()
    Dim filePath As String
    filePath = ThisWorkbook.Path & "\Workbook1.xlsx" ' Adjust the file name
    Workbooks.Open filePath
End Sub

Sub OpenWorkbook2()
    Dim filePath As String
    filePath = ThisWorkbook.Path & "\Workbook2.xlsx" ' Adjust the file name
    Workbooks.Open filePath
End Sub
This code uses the ThisWorkbook.Path function to dynamically get the folder path of the menu workbook. It then appends the name of the workbook you want to open.
  1. Save your workbook as a Macro-Enabled Workbook:
    • Go to File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm).
    • Save it with a name like MenuWorkbook.xlsm.

Step 4: Assign the Macro to Buttons​

  1. Go back to the Excel window, and select the Developer tab.
  2. Click Insert and select Button (Form Control) under Form Controls.
  3. Draw the button on the sheet and a dialog box will appear asking you to assign a macro.
  4. Assign the OpenWorkbook1 macro to the first button. Repeat the same process for additional buttons and assign the respective macros (OpenWorkbook2, etc.).
  5. Choose a caption for your buttons.

Step 5: Enable Macros and Test​

  1. Enable Macros: If macros are not enabled by default, Excel will prompt you to enable them when you open the workbook. You can allow macros by selecting Enable Content.
  2. Test the Macro:
    • Save and close the MenuWorkbook.xlsm.
    • Reopen the workbook and click the buttons or text you’ve set up to open other workbooks.
    • The selected workbooks should open automatically.

**Step 6: Compiling the Workbook **​

  1. Open the menu workbook file and choose Compile to EXE in the XLS Padlock tab.
  2. In Companion Files, add the other workbook files such as Workbook1.xlsx and Workbook2.xlsx.
  3. Compile the EXE.
  4. Test it.
Opus said:
A Macro that once clicked it opens the wanted spreadsheet ?
Will it be allowed by Padlock ?
Also if yes, what are the requirements.
do they need to be in the same folder ?
They have to be compiled too as .exe ?
Click to expand...
A Macro that once clicked it opens the wanted spreadsheet ?
Will it be allowed by Padlock ? Yes, unless you disable the behavior, it will be allowed.
Also if yes, what are the requirements.
do they need to be in the same folder ? Yes
They have to be compiled too as .exe ? Yes, as companion files.
 
You must log in or register to reply here.
Back
Top