unlock

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

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

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

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