Want to add password to spreadsheet but box is greyed out 1

[sidalam]

I am trying to protect my MS Excel Spreadsheet.
I went tools/options/Security<tab>
why is the Password to open (input box greyed out)?

 

[SkipVought]

hi,

Tools > Protect.

Both sheet and workbook can be protected.

Skip,

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

 

[sidalam]

Tools/protect
protect sheet
protect workbook
are both greyed out
why?

 

[SkipVought]

Is your workbook shared? Many feature are not availble in shared workbooks.

Skip,

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

 

[sidalam]

Yes this is truen