XLS padlock with StockHistory Function compatibility

J

jack420

New member
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?
 
Solution
J
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.
Sort by date Sort by votes
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 work book, but only when I click on the cell and press enter, then it works. After that, it works with all other manipulations of the stockhistory
 
Last edited:
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top