protect sheet

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...

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...

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...

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,

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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...

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

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...

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...

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...