protect sheet

Hi, For a long time I have used VBA code to refresh PivotTables on a protect sheet. The other day while manually protecting a worksheet, I noticed in the Allow users of the worksheet to list that there was an option to Use PivotTable reports. I was curious as this could save some coding time...

Still getting my head around VBA, and now having problems with unprotect and protect. Below is the code I have ad it worked until we password protected the worksheets to stop the users deleting the formulas. have looked at loads of posts but can't seem to fit the solutions into my code below...

Hi All, I have a 2010 excel workbook with several locked worksheet (to which I manage the PW). I and another staff member manage different section of the macro but the other staff member doesn't have access to the locked areas… Is there a way I can encrypt the password within VBA so it’s...

Hi everyone... I have created a simple userform that is linked to a button on sheet1. When the data in the userform is submitted, I set it up so it goes into a database under sheet2. The problem is, I don't want anyone modifying the entries in the database. Usually I would protect the sheet...

I need to insert and delete rows in a protected worksheet. When I set the protection, I indicate the user can access unlocked cells, insert and delete rows. After I save the worksheet and try to add rows, it will let me but it will not let me delete rows althought the access box to that task...

This code works great...UNLESS, I protect the worksheet. I need to protect the worksheet because it contains cells with formulaes. My assumption is that the hiding of row 27 upon clicking the check box is giving me the trouble - the code is opened asking me to debug. Any ideas/solutions would be...

I have a macro to protect a sheet, but enable the filter function. The macro is as follows. However, the coding disabled the filtering even I enable the autofilter and allow the filtering. Can anyone please tell me where's wrong with the macro? I really appreciate your help. Thank you...

I have a spreadsheet with various formulas that I would like to protect from others editing. If I use tools protection, it's annoying because once I apply the protection, I have to unprotect before I can edit it again. I would like to use VBA to enter in a script that reads the user name...

Hi Everyone, I have a workbook which I built up on my own for me & my office colleagues. Its a very useful for all of us and because it contains very confidential data I also password protected it but now I want to even protect this workbook such that nobody can remove the password and copy it...

I have a couple of documents with similar requirements. Locked (so nobody can screw up my functions/formulas) The document will need to be accessed by all the teachers in the department to enter raw data. Expand and collapse groups of columns (there are a LOT of columns) Use Autofilter (There...

Hi I have to make a sheet read only for some people but other people have to make changes on it. So I protected the sheet with a password. But in the sheet I have a calculated column and I want to protect this column for overwriting for all the people. How can I do this? Thanks in advance...

I use Excel 2007. I have a worksheet that is all formulas that calculate based on values entered in other tabs in the same worksheet. It will be viewed/used by a number of people and i want to protect the forumlas. I also have rows grouped in the worksheet. I can't figure out how to protect...

I have a spreadsheet where most all the cells are data validated with a drop down list. I only want users to be able to enter name, select drop down variable and finally be able to cut & paste data to other cells. My problem arises when the users cut & paste, the cell borders don't stay...