If you are talking about a protected sheet not a workbook then highlight the
entire sheet and choose Copy. Move to A1 on an unprotected sheet and paste.
Delete the original sheet the new sheet will not be password protected.

Need more detail on the second question.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Khalil" wrote:

Dear Experts;

Please advise on the following.


1.. How to recover the lost password of protected sheet.
2.. How can I do the Data Validation for Two or more colums, where
both columns data may display Simultaneously.

thanks
Khalil