Excel lock sheet

[Per9922]

Hello, I have some problem with the lock sheet function! if I tick the first three when I lock the sheet:

Mark lock cells
Mark none locked cells
Format cells

I then have two buttons on my sheet, one unlock the sheet and the other lock the sheet, when I lock the sheet, the format cells box is unticked ?

ThisWorkbook.ActiveSheet.Protect <- This will untick the format cells box, why ?

ThisWorkbook.ActiveSheet.Unprotect

Plese help

 

[Per9922]

I need to have it protected so the user dont't change stuff ...

 

[SkipVought]

You may need a button to remove protection, add rows and add protection.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}