Sheet Protection

[sturnusek]

Hi there,

I'm trying to put a code into my macro, but I struggle with finding right arguments for the code.

I'm want cells from A:F to be locked and be unselectable, and range from H:Q to be locked and selectable.

Any ideas?

Thanks

 

[Legacy 436357]

Removed by user

 

[taikvei]

Hi there,

I'm trying to put a code into my macro, but I struggle with finding right arguments for the code.

I'm want cells from A:F to be locked and be unselectable, and range from H:Q to be locked and selectable.

Any ideas?

Thanks

Select the cells you don't want to be locked, right click on them -> format cells -> protection untick Locked
make sure that the ones you do want protected have Locked ticked

when you protect the worksheet, the ones that are unticked will not be protected?

 

[sturnusek]

Select the cells you don't want to be locked, right click on them -> format cells -> protection untick Locked
make sure that the ones you do want protected have Locked ticked

when you protect the worksheet, the ones that are unticked will not be protected?

The problem is, I want my entire workbook to be protected. With the difference, that I want cells from A:F to be locked & cells to be unselectable, and cells from H:Q to be locked & selectable. As per default Workbook protection once you set a password and apply settings to the locked cells, I can only achieve half of what I want to do. I want all of this to happen within a macro, as it's going to be a part of something else that its already in place.

Thanks