|
Answer» Hi,
I have an excel spreadsheet which I need to password protect. I have opened:
Tools > Options > Security tab
The option for Password to Open is greyed out. Any idea why?
I don't know if this is relevant, but in the title bar for Excel, the name of the document is listed followed by " [Shared] "
Thanks
NickHi Nick,
YES it is relevant, you can't set a password for a shared excel document.
Go to tools > shared workbook > editing tab. MAKE sure you're the only USER who appears in the 'who has this workbook open now' list.
Clear the 'Allow changes by more than one user at the same time' check box.
It's all in the help file, just go Help then type in 'shared'.
All the best
Thanks, all sorted now.
|
