•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#dashboard
#main dashboard
#administrator sheet
#worksheet
#admin sheet
#VBA
#lock
#saved files
#pivot
#open
#send
#sheet
#saved last
#menu
#currently working