When attempting to save, the “save with password” option is greyed out
I presume you want to protect your sheet against modifications.
Try:
Tools - Protect Document - Document
Or:
File - Properties - Security Tab
If you otherwise want passwords to be entered before the document is opened:
- Click
File > Save As...
- In the
following window, make sureSave with password
option is ticked.
A dialog with password setting options will appear.
References:
Unfortunately none of the above works, the document is still opened without requiring a password