•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
Our take
Are you struggling to share an event dashboard in Excel without exposing sensitive information or risking unwanted edits? You're not alone—many users face the challenge of balancing visibility and security. Fortunately, there’s a way to lock your workbook from being edited while still allowing users to scroll through the content seamlessly. In this guide, we’ll walk you through the steps to hide unnecessary sheets and maintain control over your workbook, ensuring your data remains secure and accessible. Let’s dive in!
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Privacy Setting for ExcelSo I have a question for the excel experts out there. I’m still fairly new to excel and need help adjusting privacy settings on my excel. So I have a sheet the is labeled “Database” that stores a bunch of entries for invoices my company has for the year. I have another sheet in the same workbook labeled “dashboard” that has some sensitive financial information on it. I want to be able to share it with a coworker where she can only see the database side so she can help me enter data point, however I don’t want her to be able to see the dashboard sheet. However, I want my bosses to be able to have access to it easily, they aren’t always the most tech savvy so hiding the sheet may not be the best option. Maybe try and password protect the sheet? For reference we also only use the one drive and excel online version, I know sometimes that doesn’t offer all of excels options. submitted by /u/SwingAnxious6016 [link] [comments]
- New cells added to a protected sheet will not lockI created a worksheet that required me to lock certain cells. The worksheet needed editing so I removed the protection so I could add additional columns. One of the two columns needs to be protected, while the other needs to be unlocked for data input. I made the unlocked range in the mange protection window and resumed protection on the worksheet but all new columns remained unlocked. All original cells on the worksheet (before the new colums) still lock and those that were put in an unlocked range remain unlocked. I am predominately working in the browser mode. I have used the desktop app to make sure all cells are locked in the fromat cells > protection settings. In the Manage Protection settings under options "Select locked celld" and "Select unlocked cells" are checked, everything else is unchecked. submitted by /u/middleCHILD-problems [link] [comments]
- Viewing workbook online - protected sheet invisible in view but appears if set to editNot quite sure what's going on with this one. I have been shown a worksheet that has 2 sheets, one blank and one password protected. I am just view the spreadsheet online, I can't see the password protected sheet UNTIL I switch into edit mode. It then appears. How can I have this sheet visible to users when simply being viewed? submitted by /u/Ramjet_NZ [link] [comments]
- Excel Online... is there a way to stop users from deleting rows/columns but still allow them add and delete text from cells?Ok, I'm pretty stuck on this one and am not sure why. I'm using Excel Online (yea, I know... it sucks). I'm attempting to create a filterable table in A1:M1000 that users can enter data into. Where I'm stuck is this... I want users to be able to enter/delete (delete by selecting an entire row and hitting 'delete'), use drop downs, and filter A:M all within that range. I do not want them to be able to edit anything outside of that range (so N -> beyond and 1001 -> beyond) AND I do not want them to be able to add or delete rows/columns across the entire sheet. My hiccup is coming here... how do I lock the sheet while allowing users to add data to A1:M1000, select a row and hit 'delete', but NOT add or delete rows/columns? I've attempted to lock the entire sheet but unlock A1:M1000; however users then cannot select and entire row and hit delete. Anyone have any helpful tips for this? submitted by /u/Tacticool_Turtle [link] [comments]