Search results

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! 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! 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!

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...

Hello, is it possible to protect the exe-file with hardware-locked key and allow network users to open the file without entering the key. Only the server should ask for the key. Thank you very much! Wolfgang

Hello, in Excel 2013 Professional Plus my links to companion files work only once. When I close the file and want to reopen it I get this error message: I think, setoption helper didn’t work. What can I do? Can you help me? Thank you very much. Here is my code: Private Sub...

Hello! I have a problem with VBA SetOption Helper. A new file can be created and saved with VBA SetOption Helper. But this file can’t be opened on some Excel editions, but on other editions it can be opened. I would like to know if I have to change the VBA code and on which edition it works and...

Hello everybody! I try to compile my VBA code. I have already made several changes. But I have problems with: msgbox (vbInformation underlined) for each (following variable underlined) Application.ActiveSheet.Cells.Find(Text3, SearchFormat:=True).Activate (:=True underlined) Another error...

Hello! Is it possible to use companion files and not allow loading/saving other workbooks (even with VBA code) at the same time? Thank you very much! Wolfgang