Anyone could help me out on the below points?1) I want to protect and unprotect the sheet by password written in macro.2) how to share a sheet with someone in excel vba.
(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.