This video accompanies my post at
In this video I show how to upload real-time cryptocurrency prices from Yahoo! Finance to Excel. Then I protect the worksheet to avoid user typos and finally use VBA to allow us to refresh the protected worksheet.
Want to learn VBA? Check out my friend Jon Acampora’s VBA Pro Course at A portion of any sales generated from this link will go to me.
Please Subscribe to my channel for more Excel tips.