Search results

  1. J

    Trouble with Stockhistory Function with new update (2025.1)

    SOLVED I reverted back to 2025.0 so I have not tested this on 2025.1. It is very critical to check the boxes I have shown in the image. Then everything works perfectly for the STOCKHISTORY function! I think the issue is when you upgrade the software, all the settings are not saved as you had...
  2. J

    Trouble with Stockhistory Function with new update (2025.1)

    Background: I had a problem with using the stock history function and it was resolved. See my previous thread. However, I was using XLS padlock 2025.0 at the time. I'm not sure how much could have changed in the new update. Is it possible to get the previous XLS padlock version (2025.0) for...
  3. J

    Run time error bypass to source code

    My sheet uses a lot of VBA. I just realized that someone could force a run time error if the xls sheet is not bug proof, and go directly to the source code of an EXE application. I'm relatively new to programming, but any ideas on how I can enhance protection to the source code?
  4. J

    XLS padlock with StockHistory Function compatibility

    I think I figured it out. I didn't mention that my sheet protects itself and unprotects itself, so I should have included my sheet password into the compiler.
  5. J

    XLS padlock with StockHistory Function compatibility

    I don't have a fire wall but I realized what is happening. In my original XLSM file, I used the following function: =IFERROR((STOCKHISTORY(B1,B2,B3)),"Please type in symbol and dates to the left or paste dates and closing prices manually into columns D2,E2") This returns the value "Date" in my...
  6. J

    XLS padlock with StockHistory Function compatibility

    I have made a workbook that heavily relies on the StockHistory function in excel. However, upon compiling an EXE and testing my application, I noticed that the stock history does not work, and therefore, my application does not work. Is XLS padlock compatible with the Excel StockHistory function?
Back
Top