unprotect

Hi Friends , I am trying to unprotect and worksheet from another worksheet of same file when user selects a value from dropdown combobox. System gives runtime error 5 "invalid procedure or argument " Part of my code is : Sub ChangeSellDataSource() With...

For reasons that remain unclear some code I used to unprotect a sheet has stopped working I know it used to work before, oddly enough I can unprotect it in the manual way, by going to Review and Unprotect sheet, so I know there is nothing wrong with the password The code I have used is...

Hi Everyone, Is it Possible to have a message box appear when someone clicks the unprotect sheet button? I want to add a worning to say "This Page is Protected for a reason, Do you have permission to unprotect this sheet?" yes/no can it be done??? thanks Tony

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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