protected worksheet

  1. S

    Allow sorting in a protected sheet

    Hi all, I need to allow sorting in an unlocked table within a protected sheet. I have enabled filtering, but for some reason sorting is an issue. Every time I try and sort I'm prompted with "The cell or chart you're trying to change is on a protected sheet. To make a change, protect the sheet...
  2. T

    Timeline unable to select year etc when sheet protected.

    Hi Guys, I have searched everywhere for the past two days to find an answer/code to help me with. I have a timeline inserted based on a pivot table. I have protected the sheet and I am able to use the slicer etc. But When I protect the sheet: 1) I want to be able to use the timeline year...
  3. A

    Macro error in editing chart series on a protected sheet

    Hello, I am using Excel 2007 and have a protected sheet containing a macro within that sheet. I want the macro to change the data and it does so when the sheet is unprotected. Once I protect it, I am getting this error - Method 'Name' of object 'Series' failed. How could I fix this macro so...
  4. S

    Sort a protected worksheet

    I have created a protected worksheet and saved the workbook with vba. Users must be able to sort the worksheet but, I don't want them to be able to change content in the locked cells (autofilter works). I have recorded the vba to "Allow Edit Ranges" and added to my code. It appears I have...
  5. A

    Clearing Check Boxes in Protected Worksheet

    I have a protected worksheet with unlocked cells and a small section of check boxes. I have a "clear form" button that clears the unlocked cells however, it does not clear the check boxes. What can I add to the code below that will clear the check boxes too? Sub ClearUnlockedCells()...
  6. W

    Inserting a row with a formula into a protected worksheet

    Good Evening Excelperts I like to think I am an intermediate excel user, but like everyone I know really well the functions that I utilize daily and I know that I have lots to learn! So, first if anyone knows of a great learning resource I would happily check them out! *Keep in mind that I...
  7. T

    Changing Column Width on a protected worsheet

    Hello, I have a worksheet that has several protected cells. Several of the formulas return a long date. I'm running into a problem with making the column width while the sheet is protected. Is there a way to keep the protection and give people the opportunity to modify the column width? I am...
  8. C

    VBA Q(s), a composite task mainly regarding External workbooks

    ​Hi all, First post. I do hope that I'm complying with the norms and terms and that my question is clear and not overly complicated. That out of the way... I'm clearly a beginner, using office 2010, tasked with (and so far failing miserably at) putting together some code for my new position. I...
  9. L

    Protecting Top Row Only in a Worksheet

    How can the top row of a worksheet be protected/locked? We have a status log being accessed by multiple people who need to be able to add/delete rows. People keep putting typos in the top row however, which contains our column titles - so I want to find a way to lock that down. I have tried the...
  10. B

    Protected Workbook loss of standard green cell border

    I am seeking to run various sheets within a protected worksheet / workbook structure. I don't want to have code running within various routine's that continually have to unprotect/protect various worksheets, as this is slowing the use of the workbook down considerably. Opening the workbook, my...
  11. S

    Protected Worksheets Query

    Hi Guys I have a spreadsheet with 50 worksheets which are all protected and share the same password. Can I unprotect all sheets at one time or do I have to unprotect them all individually. Similarly can I Protect them all at once or must it be done individually. Thanks Stephen
  12. L

    Protecting Worksheet

    When I protect my worksheet the buttons at the top of the worksheet continue to work normally but the rest of the buttons on the worksheet are now locked. I had gone to Home, Font, Format Cells, Protection tab unchecked Locked and then selected the rows that my charts are in then checked the...

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