protect sheet

  1. Y

    VBA Protect and Unprotect

    Hi All, I have two problems which hopefully have the same solution. I have a template which I have created for a large user group, the template is password protected. Problem 1. When the user opens the template I have a macro which clears everything in the work sheet so that the user has a...
  2. K

    When Protecting/locking worksheet / cells / shapes, my slicers become not clickable?

    I have a worksheet that I've created as a Dashboard in Excel 2016. The pivot slicers have shapes around the slicers that make the display more appealing to the end user. I want the shapes and corresponding code behind the shapes not movable/editable by the end users. This also means I don't...
  3. G

    Protecting Spreadsheet and VBA

    Sorry to bother, but does protecting the spreadsheet and locking cells affect the VBA code results? They've been working fine, but now, when I've protected the spreadsheet, I get a runtime error. The only VBA codes I have are to hide rows when certain fields read certain things. So is the VBA...
  4. T

    Protrcting multiple sheets at once

    Hello, I have a document that has 100 sheets (all the same). Each of the sheets has cells that are protected and unprotected cells for folks to enter data. My questions. Is there a way to protect all of the sheets at once, instead of going to each one and protecting it individually. Thanks,
  5. O

    Locking specific cell

    I have already asked a similar question but I am still not getting the results I had hope for. My goal is to have for instance an entire worksheet that is locked so that other users cannot change anything. However, there will be an exception of cells like C6, C12, C18, etc.. In these particular...
  6. Hobolord

    Excel Template Questions

    Hello All! I am working with excel 2010 on Windows 7. I have created several 'templates' in excel which use a lot of formulas, macros, and conditional formatting. Of course, I have the users of these templates who keep pasting over the formulas, removing the conditional formatting, and saving...
  7. N

    Prevent Editing of Tab Contents if Criteria Met

    Is there a way to prevent editing of a tab's contents if a specific condition is met? We have a budget workbook that contains a budget estimate tab that users should not be able to change after the budget is approved. There is a second tab for submitting a revised budget. So, the user needs to...
  8. D

    VBA to protect worksheet but allowing AutoFilter on locked cells

    Hi Experts, I have a table with headers. I locked the cells that contain headers (apart from all other cells I need to protect). I have some macros to allow the users to filter the data based on the selection in a dropdown list. The macros should first unprotect the worksheet and do whatever...
  9. A

    Unhide Rows Macro issue

    Hi All, I am currently using a macro script within my workbook to un-hide hidden rows which I got from here thank you to Rick Rothstein!! It works really well until I try to protect my work sheet and then execute the script. Here is a copy of the exact code I am using Private Sub...
  10. C

    Keep table row creation function in protected sheet

    Hi, I have a table in a spreadsheet so users just begin typing in the next blank row to carry down the formulas and validation data from the row above. However, when I protect the worksheet, the table new row functionality stops working. I have tried ticking / un-ticking all the protection...
  11. D

    Unprotecting a worksheet by user ID

    Hi. I'm new to the forum so treat me gently! Can't find anything that quite answers this so... I have a workbook with half a dozen worksheets. One of the worksheets contains master data that the others call on. Only a small group of people need to be able to change the master data but everyone...
  12. S

    Dropdown List Reset macro, Protect Sheet bug

    Hi, the macro below has been working fine to reset a number or dropdowns I have on a spreadsheet, but if Protect the worksheet I get the following error: Runtime error '424' - Object Required How can I modify this macro to run when I Protect the worksheet? Many thanks in advance! Sub...
  13. R

    Unable to set user-editable ranges in locked and protected sheet

    I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire...
  14. A

    How to auto filter locked cells on a protected sheet??

    I have a workbook that has many columns (A to BH). All of the cells from A3:BG2383 are locked and the whole column BH3:BH2383 is unlocked ( I need people to input info there). Is there a way that I can protect every cell except for the cells in column BH but still be able to filter and have...
  15. S

    Macro Buttons

    Hi guys, thanks in advance for any help here, I have a small worksheet, nothing to advanced, however I have 2 buttons in it with 2 very short Macros attached to them, when I password protect the sheet I am unable to use these buttons, I get a "pop up" screen with 4 options, "Help", "End"...
  16. V

    Macro isn't working after set .Protect UserInterfaceOnly:=True

    Hello everyone, This being my first post, I hope this forum can be helpfull to me, and I can to be helpfull to others. Please correct me if my style of posting is unclear or unjust. I have a problem I am looking into for a day now, and still I can't lay my finger on it: I have a data transfer...
  17. C

    sort data when sheet is protected

    Hi Excel Gurus, Does anyone know what setting should I use in order to allow a user to sort data in a table when some of the cells are locked? When I protected the sheet I ticked the option to allow user to sort data but it doesnt work... Any help as usual would be greatly appreciated... Cheers
  18. M

    Auto hide columns and rows based on cell values. Protect Sheet.

    I have a sheet that needs to have columns hidden if the value in row 35 of the column is <0 and unhide the columns if isn't(The values in row 35 are calculated based on B8) If B8<2 then rows 64-97 need to be hidden as well and unhiden if not. I had code that worked at one point, but something...
  19. B

    Protect Workbook/Sheets and Pivot Table

    So i have this lovely workbook that I need to protect. Simple solution would be just to protect the workbook however when I do that it's disabling the part of my Pivot table that allows you to double click on an item and it gives you all the items on a new sheet. Now I'm thinking maybe I...
  20. U

    Why can't I select any cell, even unlocked cells, after my program runs unless I unprotect it?

    I am creating a form that the first person only needs a little access to but they need to see some fields but no rights to them. The next person needs to see what they entered but should not be allowed to change it. The last person needs full access. To protect the cells I am only using three...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top