Search results

SOLVED It was a problem of names (original excel file,file name used during compilation and rename after compilation). The code has to be changed, it is not possible to use “thisworkbook.name” if we want the user can change name of compiled file. Thank you for your support.

Yes I have checked both several times. Full path strings are perfect. No problem with this.

Hello, I am having a problem with some VBA functions. What I want to do is to change the .xlsc path when user move the compiled file .exe to a new folder. Therefore what I need to do is to change the path contained in the text file .dat To get the path of current folder I am using the function...

Already sent. Thank you for your support.

I have made 2 tests in a different PC and it works well: 1-Different PC with Windows 8.1, Excel 2013 32 bits. 2-Virtual machine in the same PC (Windows 10 32 bits, Excel 2010 32 bits). In both cases when running .EXE the cells with formula protection works well. The cells shows the formula...

In the same PC.

I did it, but it doesn’t work. This is what I have done: 1-I run the .BAT in the installation folder. 2-In the original excel workbook the screenshot of add-in is this: Pasted image406×404 5.71 KB 3-The screenshot of COM add-in is this: Pasted image441×278 5.71 KB 4-If I insert in the...

Requested screenshot: Pasted image429×409 5.81 KB The COM add-ins screenshot as well: Pasted image506×280 6.33 KB

I have made a test with new version 2.2.1 but the problem with #NAME is not solved. When I am in the original Excel workbook I can not insert the function PLEvalForm. You say in the user guide that Excel can recognize the category GXLSForm.GXLSFormula. In my case Excel does not recognize. Any...

What happen is that the cell shows "#NAME?

I have run XLS Padlock Manager and now the internal add-in is not disabled but the issue of #NAME is still there. I have checked the registry key and you can see below the only entry I have. I think it is not a XLS Padlock entry. Pasted image935×254 7.79 KB

Before generating .EXE the “XLS Padlock Formula and VBA Protection” I turn it on , but after building the .EXE is turn off automatically by the system. I have tested several times and it happens this all the time. I don’t know if this heps you to know what’s happening.

By pressing CTRL+ALT+SHIFT+F9 nothing change. XLS Padlock Formula and VBA protection add-in is selected. Should I enter here some add-in?: Pasted image815×353 13.4 KB

Nothing happens.

I have tried it but nothing has changed. The same problem (cells with formula protection are showing #NAME?). I am testing a simple multiplication formula of 2 cells. I am using V2.2. Excel 2016 32 bits, Windows 10 64 bits.

Excel 2016. Formulas: TODAY (), SUMIF

I have a problem when using formula protection. When I protect a formula then in the .EXE the cell is showing “#NAME?” instead of showing the result of the calculation. I don’t have any worksheet password. I am following the steps of your guide. I am using V2.2. Probably I am missing something...

I am using password protection in all sheets and the workbook structure but this is a weak protection if the user has the excel in .XLSX format. As you know, from this format it’s quite simple to unprotect the whole workbook. It is well explainned in internet.

I can not use the option you suggest because my application needs to open other workbooks. Sorry to say this is a major security gap in XLSPADLOCK. You have an excellent tool that I have been using for more than 1 year but I am really surprised the possibility to disable autosave is not already...

I have realized about a potential gap in the protection of XLSPADLOCK that I would like to clarify. If the Excel option “autosave” is activated then the original uncompiled Excel workbook is saved automatically by Windows in the defined path. In my case my original workbook is Application.xlsb...