Basically, I need an automation for my XL dashboard so it would show several pages (Worksheet + Charts) in the order as specified in the Display Setting Tab as well as the duration of showing each of them in a simple list as follow:
Col. A: Order #
Col. B: Sheet Names
Col. C: Duration (sec)
The showing pages should only display the page content, it means no ribbon, no formula bar, no worksheet tabs, no headings, no horizontal and vertical Scrollbars.
When the user press a key combination (shortcut key), it will activate a macro to start the slide show. Every time it shows a page, the macro should Calculate the workbook/worksheet so it will update all figures. The user should be able to stop the Slide Show by pressing another shortcut key, otherwise the slide shows will continue repeating back to show the 1st order page after the last one is displayed and its duration time has been reached.
5 freelancers are bidding on average $143 for this job
I'l do it in visual basic app. so it this could be a stand alone app system. And this will be a user friendly instead in Worksheet form in Excel. I wanted to be done by myself if you pick my bid. Thanks,.