Recent content by wkullek

Hello, is it possible to use on another computer Excel files in which I have used the VBA compiler without creating an *.exe file? At the moment I get an error on the line: Set XLSPadlock = Application.COMAddIns(“GXLSForm.GXLSFormula”).Object Instead I was able to use on another computer my...

Hello, your answer to my other question solved the problem. I have different files. Thank you very much!

Thank you very much. That’s great. It works fine!!!

Thank you!!! Yes, my other files are companion files. How can I use the compiler now? Greetings and have a nice day!

Thank you very much for your help on a Saturday. I have a main file with the code and several files that use the main file’s code. In that case is it impossible to use the compiler? Thank you very much again and have a nice weekend

Hello, I’m still looking for the solution of the compiler problem. I always get the following error: Why does the first sub work fine and the second one produces this error? It doesn’t matter what I put in the second Sub. So my questions about protecting and calculating sheets are not actual...

Hello! Can you tell me, what is wrong with this short sub? Sub aktualisieren_Abfrage2(Param1) Application.ActiveSheet.Calculate End Sub I don’t understand the compiler. Why do I always get the error that I have to recompile the code? Thank you very much!

Hello, what syntax does the VBA Compiler accept to protect and unprotect a sheet? I get “Please open the VBA compiler of XLS Padlock and recompile your code.” with: ActiveSheet.unprotect Password:=“xyz” Thank you very much!

Hello! I would like to know how to use the find method in VBA Compiler. I have tried many different ways, but I always get an error. Sub abc(Param1) Dim x x = Application.ActiveSheet.Range(“A:A”).Find(“house”,false,false,false,false,false,false,false,false).Row End Sub Thank you for any advice.

Hello, thank you very much for your answer. It is in my VBA Editor. With Dim res as String I got an error because of 0. But in the morning I tried Dim res without anything and it seems to work.

Hello! When I try to protect a sub then I get the error that res is a variable without definition. Sub abc() Dim res As String res = CallXLSPadlockVBA(“abc”, “”) End Sub 'This function lets you call VBA macros compiled with XLS Padlock Public Function CallXLSPadlockVBA(ID As String, Param1)...

Hello everybody! Can you help me? I have activated "Do not allow loading/saving other workbooks . I use the SetOption helper. I have a companion file (filename.xlsb or filename.xlsm.) I can open it, I can save it under a new name, but I can’t open the saved file. Dim XLSPadlock As Object...

Hello! Can anybody help me? Somebody got the error message, that the main file cannot be opened. Error no 1004. And Error: access denied. Thank you very much!

Thank you very much for your great answer, Paul! I am sorry for the delay. I understand well that you are talking about hardware locking in the first paragraph. As I want my workbook to be used in a network this option has the disadvantage that every user would be asked for data of his PC. The...

Hello, I have read the XLS Padlock Activation Kit Guide. Can you help me, please? I don’t see the copy protection. If somebody copies the workbook.exe file to somebody else and shares the data of the registration form, does this person get the permission from my URL to use the file? Thank you...