protected worksheet

I'm trying to create a tracker that my employees must update. Each employee has their own worksheet. The first worksheet is a splash page where they can click their name and it will automatically jump to the worksheet assigned to them. There is also an overall worksheet for their leadership...

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

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

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

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

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

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

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

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

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

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

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

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