protect/unprotect macro

  1. K

    Sorting column in protected worksheet that has a macro

    Hi, Firstly, I have a very limited Excel vocabulary and experience with macros so please forgive the awkwardness of my question. I have created a protected excel worksheet sheet which contains macros that colleagues in different states fill in. My colleagues would like to be able to sort the...
  2. V

    How to Protect and Unprotect the same data range in multiple sheets AND modify this range each month. Excel 2010

    This forum has already helped me to add a macro to protect and unprotect all the sheets in my work book. The one piece of the puzzle I am now missing is the ability to quickly change the range which is left open to be edited in all the sheets at once. Currently I can now protect and unprotect...
  3. O

    Unlocked Combo Box displays protection error when clicked

    I have a Combo Box (Form Control, not ActiveX) which is Unlocked. When I protect the worksheet it returns this error when I click the box: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the...
    • osianllwyd
    • Thread
    • form control locked object protect/unprotect macro unlocked
    • Replies: 1
    • Forum: Excel Questions
  4. V

    Many WorkBooks to Summary WB

    Hello to one in this wonderful forum! I need some help on a Macro. I have a folder with many Excel WorkBooks in it. All the WBs are encrypted by the same password. The data in these WBs are in Sheet1, in the Column C5:C10. The Macro should open each WB in the Folder and copy the data from...
    • vinayguj
    • Thread
    • protect/unprotect macro summary worksheet workbook copy range
    • Replies: 5
    • Forum: Excel Questions
  5. B

    Enable ActiveX control in protected worksheet

    I am stuck! I have a worksheet that is protected. However, I have an ActiveX control button that I want users to be able to use. I have tried building in the unprotect functionality into the ActiveX control as follows: Sub PrefSelection() ' ' PrefSelection Macro ' ' Sheet13.Unprotect...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top