unlock

  1. B

    VBA Code HELP!!!

    Trying to write a code that will accomplish the following: 1. If cell "H16" is "Yes" then unlock range E47:E53 2. If cell "H16" is "No" then fill range E47:E53 with zero's and lock. Given-working on Sheet5, and let me know if the range E47:E53 needs to be normally locked or unlocked. Also...
  2. T

    Locked check boxes and option buttons

    I have a sheet that i´m trying to protect and allow users to edit certain ranges, when doing so I can´t unprotect check boxes and option buttons. The cell that they are placed in are unprotected and so are the cells linked to the check boxes and option buttons. Even if I allow to edit the whole...
  3. S

    Excel VBA Lock up

    Hi, I created a budget template file for users to fill in which uses the "xlveryhidden" function on a worksheet that holds the data that will be extracted and rolled-up to get the total company figures. The VBA project for this template was locked with a password. I have come across a...
  4. StuLux

    Unprotect Option Buttons

    I am using option buttons from the Forms toolbar but when I protect the sheet (even though both the cell where the option button lies and the option button itself is unlocked) its still telling me that the cell is protected, how do i protect the sheet so that you can still use the option(radio)...

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