(1) Record a macro of yourself protecting and unprotecting the sheet, thenedit it to suit.(2) Don't know what you mean - please explain in more detail.