Protected workbook - Lock More Cells

[mattbarb]

Hi,


I have a workbook which has a number of projected cells by default. I want to create a VBA that will enable me to press a button that locks certain additional cels, is this possible?

Thanks,
Matt

 

[steve the fish]

Well you can changed the locked status of cells with vba yes but all cells are locked by default. That status is only used when the sheet is protected though.