•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Locking Workbook from being Edited with Movable Scroll Bar range
I'm still new to excel... The event dashboard I'm currently working on will be distributed to the whole company staff, is it possible to:
- Hide the rest of the sheets except this one and not let other people to access and see it (like, ever)
- Lock workbook from being edited, but still able to scroll the scroll bar (red square)
I tried protecting the sheet to prevent it from being edited but then it'll show this every time i tried to scroll the scrollbar.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#google sheets
#real-time data collaboration
#financial modeling with spreadsheets
#Excel
#Lock workbook
#Hide sheets
#Workbook protection
#Protecting sheet
#Editable
#Access control
#Data security
#Scrolling issue
#Movable scroll bar
#Event dashboard
#Worksheet access
#Sheet visibility
#Company staff