unprotect

  1. S

    Userform Entry only?

    Does anyone know if we can restrict entry to a worksheet thru a userform only? I think it can be done through protect unprotect, but I was curious if there is another way.
  2. P

    Macro to unprotect worksheet not working

    Hi, I'm sure there is a simple solution, but I've been Googling this for almost an hour. I need a macro to unprotect, then re-protect, a worksheet. The following doesn't seem to work: Sub Unprotect () ActiveSheet.Unprotect Password: "my password typed here" End sub When I run the...
  3. J

    Clear Cells, Leave Formulas

    I have a spreadsheet that will be used as a template to enter data and then the sheet will be saved as a CSV file with a command button. Once it saves the file it come back to the template and asks if user wants to clear out the data. In order for this to happen and not lose the formulas the...
  4. S

    Macro to remove password from project code

    Hi All, I would like to have a macro which before closing Excel, will unprotect Excel project Code (I know password) with Excel VBA code, to be clear, to run a macro which will unprotect Excel project Code. Thank you in advance
  5. W

    Lock / Unlock Project using VBA

    I have a macro that creates activex buttons based on the selection of the user. I then add VBAA to the buttons so they can perform specific actions. Here is part of the code that does that; ' Adding buttons to the capture sheet ' Data collections for adding buttons Dim ButtonNumber1 As...
  6. H

    PROTECT: User Interface Only not working

    Hey guys, Im having problems with my sheets being protected and macro's not working. I attempted to use the interfaceonly option however it doesnt seem to be working. My code is below. It prompts me for the password and works fine. However when i run a macro, it doesnt work. Can anyone see...
  7. C

    Protect and Unprotect Specific Worksheets

    Hello All, I would like a Macro/s that is/are able to protect and unprotect specific worksheets. This is so that other Macros can then access the data on these sheets. Currently I have a Macro, taken from another thread, that Protects and Unprotects all of the worksheets. This works fine...
  8. M

    The Unprotect option is not available to me. Why? How to Get it Back?

    Hello! My Unprotect button is grayed out for the worksheets that I just set up with a password to protect them. What could I have done for it to gray out completely? I have the password but I am not given the option to enter it!!! Ahhh! Help please! "Remove protection from a worksheet 1.On the...
  9. G

    VBA Issue with Worksheet Protection Passwords

    Hi all, I'm new to the forum although have been helped by it on many occasions. I have come across a problem while trying to use VBA to protect my worksheet and was wondering if anyone else has had a similar issue. Essentially I am adding two levels of protection; one level for the end user of...
  10. E

    Temporarily Disable auto protect code

    Is there a way I can temporarily disable automatic protecting in the following code? Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Application.EnableEvents = False ActiveSheet.Unprotect Password:="WellingtonFrac" Set rng = Intersect(Target...
  11. I

    How to Trap Unprotect Event

    Is there any way to TRAP the .UNPROTECT Event in Excel ? :eeek::confused:
  12. J

    Macro: find/open/unprotect/unhide/copy/paste...

    Hello, I need help with a Macro. I have found the individual elements but tying them all together where I'm unsure. What I need to do is have a macro in (Workbook A) that will… open a workbook based on a file path in a specific cell (Workbook B) Unprotect Workbook B Unhide a specific sheet on...
  13. A

    Unprotect sheet button stops working

    Hi all, I've written some code which assigns a temporary password to excel and locks all cells in the workbook before reassigning the original password. This seems to work fine, however, I've noticed that once the code has been run the sheet can be unlocked by simply pressing the unprotect...
  14. E

    Running a Macro with a Protected Sheet

    Hello, I have a macro running to hide/unhide certain columns depending on a user's selection in the drop down menu(s). I then unlocked the drop-down menu cells and protected the sheet. When I do so, the following error shows up: Run-time error '1004": Unable to set the Hidden property of the...
  15. L

    Unprotect Workbook in a Macro

    How do you turn off the the protection on workbook in a Macro? Using Outlook 2013 I have a macro that after I lput in my passwork and run the macro, it takes the protected file, removes links, removed data, and saves a stripped down version of the data. My issues is when the other users get...
  16. K

    Protecting sheet using cell value works, but not unprotecting? - confused

    Greetings Everyone! I have a worksheet that i have been using a macro to protect/unprotect the sheets. Recently, i thought instead of having the password visible in my code, i thought i'd hide it in a veryHidden sheet. (i can't just hide the code, as i have granted this workbook access to VBA...
  17. E

    Protect workbook for read only unless have password

    In prior versions of excel, you can protect a workbook and users when opening the file would be asked to enter the password to open with full editing priveleges or allow the user the option to open as read only. Apparently things have changed a bit in Excel 2010 and I cannot seem to replicate...
  18. J

    return to previously selected sheet and password protect

    i have this code in my workbook that runs each time a user saves the workbook. problem is that i want to password protect the sheet and then return to the sheet the user was previously working in. so looking for 2 modifications to my code below: 1. to unprotect the sheet, then protect it when...
  19. T

    Macro no longer works in Excel 2007

    I have a workbook / macro that no longer works since I moved to Excel 2007. When running some code that hides / unhides rows it gives me The offending line of code is Rows("35:40").Hidden = True Now, I thought this may be due to the worksheet being protected; however I do have the code...
  20. A

    Help, with password

    Hi!, I been working on a pretty confusing excel format, but on somehow ~~' made the big mistake than any can ever make... Forgot the pass... Can any one help me to figure it out; or if it's possible break it down, and then explain me how you did it. I don't know how to use VBA... Already try to...

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