[scouse13]

is there a way using vba, that if a worksheet is protected,macro's,formula's and checkboxes(both form and activex still work.
my problem is two columns allow data entry and the others either have data in that i don't want changed or contain formula's which perform , an action on another cell, the same applies to the checkboxes which when returning a true value alter the colour of adjoining cells

[computerman29642]

If you are going to use VBA, then you would use code to unprotect the sheet, and re-protect the sheet obce the code has ran.

Do your current macros change data in the locked cells on the worksheet? If not, then even if the cells are locked, the formulas should still work.

Let us know exactly what it is you are trying to accomplish, and we can let you know the best way to achieve that goal.

[scouse13]

thanks computerman

yes i need the current macros to be able to change data in the locked cells