protect

  1. P

    Restrict Paste to Paste Values using VBA

    Hi everyone. I have a spreadsheet that users will have to populate. Some cells are totally locked, others are available for users to input data, others have data validation (lists). The first question: I want users to be able to Paste as Values in certain cells (ie, I don't want them to just...
  2. L

    Protect Borders When You Copy & Paste

    Hi, I have an Excel 2010 spreadsheet with borders around selected cells, the spreadsheet is protected so my formulas can't get corrupted, but with some cells that are unlocked for user data entry. But when you copy and paste in these user entry cells the borders are getting copied and...
  3. W

    How do I protect part of a spreadsheet & allow others to add to it?

    Hello, I have an Excel document that is on a shared drive with another department where I work. I need to be able to enter information into certain columns & keep those columns protected (this other department has managed to disorganize the information in the past), while allowing others the...
  4. M

    Lock a worksheet after certain date is passed

    Hi there I'm trying to find a macro that I can place into a worksheet to lock it for editing after a certain date passes. I could do with them being able to view it still. I already have the sheet protected as I didn't want people the edit the layout so if there is another way other than using...
  5. D

    Sort Protected Table?

    I have an excel worksheet (2007) that is in a table format. Several of the columns contain calculations which I have hidden and would like to lock so that users cannot change the formulas. The users need to be able to edit the visible cells, sort the table, and hide and unhide the unlocked...
  6. S

    Run Protect Macro on Close

    Excel 07. I have unprotect and protect macros that run when I click on two different buttons. Sometimes, the tech (end user) forgets to reprotect the workbook before closing it. How can I get the macro I already have (which protects 7 worksheets with different passwords) to run automatically...
  7. G

    Gabriel

    I have created a sheet for entering data into some cells by useres. I want to protect the whole sheet to keep all formats (colors, validations, etc.) on the sheet. I want to enable only the entering data without any other modify of cells. The problem is if I lock a cell the user can not enter...
  8. K

    Protecting Information Within a Cell

    Let's say in sheet1 cells A1:A5 are names, and in B1:B5 are their salary information. In cell C6 I sum the salaries. I am going to hide column B and lock all cells in sheet1. I have no problem w/ that. Let's also say I need the users to be able to edit all cells in sheet2. But if someone...
  9. Z

    Setting Sheet Protection Options in VBA

    I have a coworker who has a workbook with several hundred worksheets. They need a single column (the same in each) protected from editing (contents) in each of the worksheets. I wrote some VBA to do it (below) that asks the user for what column they want protected, then asks them for their...
  10. L

    Avoid Copying Cell Protection Without Macro

    I need help finding a solution to the following problem!: I have a range of unlocked cells pinned on the corners by locked cells. Users are allowed to only select unlocked cells. Therefore the user cannot select the first or last row or column (thus nor can they delete, which is the intent)...
  11. F

    Unload Userform protect sheet

    I been searching the forums and I am sure this is quite easy to do but a little stumped. I have a userform where users only put in certain criteria. I have been asked to create a button where the user can unload the userform, and be able to print the worksheet, but the worksheet is protected...
  12. P

    protect number format

    I have a column (A) that can contain wither text or numbers. I have set the number format to be with four decimals and % (ie. 12 would be 12.0000%). I want to protect that number format. The column is already protected, but if people copy a number from another column X (say, the copy the number...
  13. M

    protecting, unprotecting workbook macro error

    i have this code found on the net for protecting/unprotecting my workbook, however i am unable to work out the password, i have tried Password Input and changing it to other passwords but cant figure out what i'm missing. sure it must be simple but just cant see it, any help appreciated...
  14. Gerald Higgins

    VBA - Password protect sheet AND allow filtering

    Hi all. I'm having problems with a macro that should a) Turn worksheet protection on for a specific worksheet b) Require a password to turn it off c) Allow filtering, while worksheet protection is on. This is part of a larger AutoExecute macro that does a number of other things, which all...
  15. W

    Locking Rows Conditionally

    Hi, I wonder if anyone can help me work out how I can lock a row conditionally by checking whetrer a cell within that row contains a date 7 days previous. thanks, C
  16. R

    MoveAfterReturn disabling fails

    I am working with Excel 2007 and I would like to protect the worksheet, limit selection to unlocked cells and disable MoveAfterReturn. Wether I do this manually or with code the result is the same. If you disable MoveAfterReturn and Protect the worksheet only allowing selection of unlocked...
  17. O

    Protect against to be erased

    Hi everyone, I have a Form that people must fill, so I unprotect those cells, and protect the others to prevent they type into cells with important values. That is right, but is not safe at all and there are some ideas that I cannot achieve: 1. The first is that I'm woring about they could...
  18. S

    This should be an easy one for ya'll....

    I am protecting a workbook and have selected the fields that can be manipulated by others. Here's the deal....I want them to be able to press 'tab' and be taken to the next cell that will allow them to type in information rather then them having to use the mouse to click on the specified cell...
  19. E

    VBA for each sheet

    Hello Using excel, I want to do a few things. 1. Have a multiple tabbed worksheet for a business and have pages protected. I recognize you can use Review, protect sheet for each sheet or protect workbook....but I want to be able to have each respective department have their own credentials to...
  20. B

    Protect a workbook when password is disabled

    Protect a workbook when password is disabled How can I protect an excel workbook solution I’m doing at work on my own. It is lodged in a remote server. 1) To safely back it up, I cannot save it to a portable memory key. I can receive e-mails there but I cannot send them, thus I cannot send...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top