Search results

Thanks for that. When I were trying to get around this issue, I encountered another problem with the compiler. The below code just refused to work. I really don’t know what going wrong here. Sub MAIN_XP (Param1) Dim sh as worksheet Set sh = Application.Worksheets(“Sheet1”) 'LastRow =...

I’m trying to find an effective way to get the last row/column which have data on it. I have no problem with VBE, but a big problem with VBA compiler as it refused all my current working functions. It is really annoying me as this compiler does not support vb constants ie. xlUp, xlLastCell...

It appears that the SELECT CASE does not work properly in my code below. I would expect the second case message would show up, but it wouldn’t. What am I missing here? Sub MAIN_XP (Param1) Dim a as double a = 2.5 Select case a Case a >= 3.0 and a <= 4.0 'First Case Msgbox(“OK”) Case a >= 2.0...

It works. Thank you.

An error was thrown at Set pt = New Collection How can I work around this error?

In the v2.5.0, i have no problem with saving secure file.

I’m using Excel 2013 and 2016. Same problem happens when i tried to save the secure file to the same name from second time. I work around by saving to different name say file1, file2 and so on. That problem does not happen to the exe file compiled by v2.5.0.

Thanks for replying. What’s does the number 12 in the vararraycreate function mean?

I got a compiling error with the following code: Dim XS2RunList() as long How can I get the VBA Compiler work with dynamic array? I also got compiling error with other misc. constants ie vbYesNo, vbCrLf, xlNone, xlContinuous, xlInterrupt,xlErrorHandler How can I get around them?

Never mind, I found it. It works. This is my first compiled sub, hope that someone may find it helpful. Sub Test1(Param1) Dim ws As Worksheets Set ws = Application.Worksheets(“TEST”) ws.Cells(2,1).Value=1.1223566 End Sub I replace this in the VBE ’ This function lets you call VBA macros...

How can I use Cells object instead of Range in VBA Compiler?

Thanks for your prompt response. I highly appreciate it as it indicates the excellent support from XLS Padlock. I was unable to do the same thing to your provided exe file. It appears that that file was compiled using a newer version rather than the current version that I’m using which is...

Another bad news, sorry. Even with the “Disable all ribbons and toolbars” selected when compiling, the protected workbook is miserably stripped after 5 sec.

Thanks for replying. I really concern about the safety of the protected workbook, hence I conducted a couple of ‘penetration tests’ to see how safe it is from the position of an average user. Here are my results: XLS Padlock doesn’t disable all existing Excel add-ins when loading a secured...

According to the manual, XLS Padlock creates a temporary virtual hidden drive and saves the protected workbook there. Is my protected workbook with vba code safe in that drive?