protect cells

  1. K

    VBA Only Protect Populated Cells

    Hello, I need to create a button that allows a manager to lock all data input, but will then allow other users to add to the sheet below what has already been locked. I know how to set up the button and password, but everything I do to protect the sheet ends up protecting everything --...
  2. A

    Protect Sheet Using VBA

    Hello, I have a sheet that automatically updates based on information entered by the user. I need certain cells to be protected, and others not to be. I've tried the following script: sh2.Range("B2:D2").Locked = False sh2.Range("C4:D4").Locked = False sh2.Range("C5:D5").Locked = False...
  3. M

    How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

    Hi, I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information. How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells...
  4. R

    Clear cells in workbook while leaving Formulas and headers intact

    I currently use Excel spreadsheet to enter time sheets before I send them off to be processed. I currently use the current week time sheet (adding and deleting employees as needed) - and then after I enter the weekly time I save as the current week but use SAVE as new workbook and clear cells...
  5. J

    Lock cells with a random password

    Hi I need a way to lock cells permanently, so not even I can get back into it. e.g. Lock cells A1 to A10. I can't know the password. I can't alter the VBA code to get back in. Is this possible? Cheers!
  6. E

    Macros and Sheet Protection Criteria

    Currently, my excel has multiple macros that are linked to buttons and another excel embedded. The only purpose of the buttons are to hide/unhide rows. Right now, when I protect my sheet, I check mark the boxes labeled "Select unlocked cells" and "Edit Objects". My macros are set to unlock the...
  7. G

    Auto Protect when saved

    Hello All, Can anyone help with auto locking cells when the saved button is pushed. I used the code from the following thread, but the thread has since gone dark: http://www.mrexcel.com/forum/excel-questions/686259-auto-lock-cells-after-data-entry-when-file-saved.html My problem is similar...
  8. V

    How to Protect Sheet from editing in Multiple Workbooks at once?

    Hi, I would like to protect a particular sheet from editing in various work book files available in particular folder. In the sheet i need to enable editing option only particular cells which. Rest all i want to protect For Ex: File Name: workbook1.xlsx Sheet Name: sheet1 In a folder i have...
  9. T

    My macro does not work when I protect worksheet

    Hello All, I have placed an ActiveX controls button in a worksheet that will perform a macro. I want to lock the worksheet so that users can only access the cells I designate and also run this macro to validate their data input. My issue: When I run the macro with worksheet locked, the macro...
  10. F

    How to auto protect worksheet and allow user to edit range

    Hello, I currently use a VBA to auto protect my worksheets upon closing the document. If users do not have a password, they can view the document but, they cannot edit. I want to allow those who do not have the password to only be able to edit a range of cells. How should I write the code...
  11. C

    vba to automatically switch on cell protection in unprotected cells

    Hi I have a locked table in which some columns contain protected cells which always remain locked by the macro. Other columns are not protected to enable users to input data or select drop down menus. I need to change the unprotected cells in a row into protected cells so the macro will then...
  12. T

    Protect Past Data from editing (<= TODAY)

    Excel Experts, I need your help in creating a lock for past data for my Inventory List in Excel 2007. Ideally, I'd like to record macro that will select a list of data that were input before today, and lock these cells. I know selective cells locked can be done by doing this; Lock or unlock...
  13. C

    Is it possible to protect different columns with different passwords in the same Sheet?

    Is it possible to protect different columns with different passwords in the same Sheet? I am trying to protect different columns with different passwords so different users can only write in their own column? Many thanks
  14. P

    Deleting ranges and protecting sheet not working as expected

    Hello guys, I have used below code to delete ranges and create ranges and then protect sheets. For one sheet (Scorer) it is working perfectly but for second sheet (Instructions) it is giving Protection error when I clicked on C2 cell. Please let me know if I am doing anything wrong here? Sub...
  15. H

    Protecting cells so they cannot be input into

    Hi! This very probably has been covered before, but I can't find it. I have set up a sheet for users to input amounts into. I don't want them to alter any headings or totals. How do I best 'protect' the cells I don't want to be changed (ie messed up :) ) I get I can protect the whole sheet...
  16. A

    Protecting a Worksheet

    Is there any way to protect a set of columns in a worksheet and still allow users to add rows or cut and paste rows without un-protecting those cells first? I have a form that needs to be used by several departments and everyone is worried about the other messing up their work, but the document...
  17. I

    Sequencial validations in adjacent cells

    Hello all, Below please find the current code I am using to validate my values. Right now I have that upon entering a value in a cell it validates if it is between a certain range given by values in two cells, display a message and regardless if data valid or not locks the cell. What I...
  18. M

    Secure a row when trigger cell is populated.

    I have a variety of spreadsheets I would like to apply this to so specifics are difficult. What I'm trying to write is a method to take all of the information in a row, change any formulas in the cells to hard data, then protect the whole row when a certain cell is populated. The trigger...
  19. B

    Lock individual cells

    I want to protect individual cells in a sheet. I am working on a shift report for my place of business and want to lock certain cells so that the staff are not able to make changes to some cells but are required to enter data in other cells. Therefore I do not want to protect the whole sheet. I...
  20. W

    Conditionally protecting a cell if it has a certain value

    Hi all, first post here. i'm Wonky1 from winkywankywoo (lol?), and although i've had a little experience with Excel, i'm a complete novice with vba. Using Excel 2007 and Windows Vista, i've been trying to find a way of temporarily protecting a cell if it has a certain value, until a different...

Some videos you may like

This Week's Hot Topics

Top