Disabling password command when opening workbook

[LabelAid]

I have lock certain cells in my workbook and added a password to it. I am looking for a way to disable the initial password prompt command for when another user opens the file.

Thanks

 

[Jaafar Tribak]

I have lock certain cells in my workbook and added a password to it. I am looking for a way to disable the initial password prompt command for when another user opens the file.

Thanks

Are you referring to workbook protection or sheet protection ?

If sheet protection, the users won't be prompted with a password prompt.

 

[LabelAid]

I just tried it again with only sheet protection. When I went to open it did prompt the user to enter a password.