•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatically open main dashboard sheet and not pivot/admin sheet on saved files
Our take
Imagine a streamlined workflow where your main dashboard is the first thing users see, while the admin sheet remains hidden from view. Currently, if you save a file with the admin sheet as the last opened tab, it defaults to that view when shared, potentially overwhelming recipients with unnecessary complexity. To enhance user experience, consider adjusting your settings so that the main dashboard opens automatically instead. This way, you maintain focus on key insights without exposing the intricate details of your admin sheet.
Currently working on dashboard right now,
I'm wondering if i could save a worksheet with administrator sheet last open, but when i send it to other people, they'll view the main dashboard instead of the admin sheet/messy part...
even though the admin sheet is locked by VBA, if it's saved last on other sheet it'll open on that one instead of the main dashboard menu we want to show
[link] [comments]
Read on the original site
Open the publisher's page for the full experience