GMC The Macro Man
Board Regular
- Joined
- Mar 23, 2023
- Messages
- 102
- Office Version
- 2021
- Platform
- Windows
Hi guys
I have a Workbook with over 30 sheets and my client complained about having to scroll along the bottom to get to the TAB they wanted to open, so I created a HOME page
with Buttons / Links to each TAB. I then hid the Sheet Tabs at the bottom by going to File/Options/Advanced and then unchecking the Show Sheet Tabs box.
This works great in the Desktop version however when my client opens this in Excel online or saves it down to Teams and then open it, all the Sheet Tabs are visible again.
Is there a way to hide the Sheet Tabs when using Excel Online
Thanks
I have a Workbook with over 30 sheets and my client complained about having to scroll along the bottom to get to the TAB they wanted to open, so I created a HOME page
with Buttons / Links to each TAB. I then hid the Sheet Tabs at the bottom by going to File/Options/Advanced and then unchecking the Show Sheet Tabs box.
This works great in the Desktop version however when my client opens this in Excel online or saves it down to Teams and then open it, all the Sheet Tabs are visible again.
Is there a way to hide the Sheet Tabs when using Excel Online
Thanks