Selected Answer
Hi Mark
I suggest you use Excel for the Web to do this. It doesn't support macros but in the example attached file I've used shapes which are linked to other places in the file so you can navigate by clicking the buttons near the top of each page. For now there's a demo link below (after the explanantion).
This is how I did it...
Create your shapes- I chose to make 3 TextBoxes - and change the fill etc. Then right click, choose Link> then, in lefthand bar, choose "Place in this Document".
For the View... buttons I opted for Cell reference (typing a cell and picking a page from the right). You could chose to other particular cells of interest for users on sheets.
For Return to Start, I chose Defined Name, and selected "Origin", having first assigned ther name to the grey cell A4 in the Start sheet (via Name Manager).
I then multi-selected those 3 shapes and copied them to the same place in the other sheets and saved the file to One-Drive. As you move between views, the buttons stay where they are.
To share that, go to Office online, log in, pick Workbook and choose the file (it should be listed in the bottom half of the page).
Check that the buttons work (and click the tabs as usual) to check). Then share it- choose menu File/Share then pick Share With People.
You wanted to share with everyone so, in the Send Link requestor which that launches, click the green globe icon then Click the > arrow by Anyone with the link can edit then under More Settings, change Can edit to Can View. Click Apply. Send via email or choose Copy Link.
This link should work on a PC (or a mobile device) but I'll remove it once I get your reply:
Web worksheet navigation demo
Rather than allow everyone to view, I'd suggest you click the "Specific people" button instead. Change the down arrow below it to "Can View". Click Apply then add an email address (say yourself), then Send. Open the email and follow the link.
Hope this works for you. If so, please remember to mark this Answer as selected.
