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.
The issue is, it won’t all fit on one page, is there anyway of the workbook auto scrolling to the bottom of the table and then starting from the top again?
I’m presuming you can through VBA but not used it too much so if someone has a guide or a method of doing this so it looks professional in the office please let me know. Just incase this matters too, this document will be stored on a sharepoint site and opened live, not sure if the VBA carries over but users will be updating this table via their own machines and hopefully the one on the TV will update automatically.
Thanks
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. The issue is, it won’t all fit on one page, is there anyway of the workbook auto scrolling to the bottom of the table and then starting from the top again? I’m presuming you can through VBA but not used it too much so if someone has a guide or a method of doing this so it looks professional in the office please let me know. Just incase this matters too, this document will be stored on a sharepoint site and opened live, not sure if the VBA carries over but users will be updating this table via their own machines and hopefully the one on the TV will update automatically. Thanks Read More