Forum Discussion
Solved
Auto-scroll an Excel workbook
Hi Guys, Looking for some assistance, I am hooking up a mini PC to a Samsung Smart TV to display an Excel spreadsheet, bascially highlights what projects we have on and some info in a table. ...
DylanBrown It should continue to run just fine, the code looks at the current size of the table each time it runs.
JKPieterse - Thanks for this, I've just tried to run this now but I get the below error. Do I need to change something in the code to suit my workbook?
Ah nevermind, I didn't put it in a new module, that seems to be working now, thank you. Is there any risk of excel crashing if this is set to this permanent?
Also, we have this document in a shared library, so people will be adding data to it, if this is opened whilst people make amendments will it update live or will I need to add some VBA to update the doc every minute for example?
Thanks
Also, we have this document in a shared library, so people will be adding data to it, if this is opened whilst people make amendments will it update live or will I need to add some VBA to update the doc every minute for example?
Thanks
DylanBrown It should continue to run just fine, the code looks at the current size of the table each time it runs.