Hello. (Excel 2007)
In 2003 I was able to create or amend a password to open or modify a workbook, via Tools/ Options.
In 2007 it seems I can only do this using the Save As dialog. Does this mean that I can only change or remove a password by saving it to a different file?
I am aware that these passwords are not secure, and presume that the Office button, Prepare, Encrypt Document option is intended to replace the previous method?
(Although this doesn't allow me to set separate passwords to open or modify). Thanks, Andy.
Password to open setting
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Password to open setting
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Password to open setting
The password that you set in Office button > Save As > Tools > General Options... is the same as the one you set in Office button > Prepare > Encrypt Document. If you change it in one dialog, it'll be changed in the other dialog too. So you can set or change the password without saving the workbook.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12615
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Password to open setting
You can use the Tools button on the Save As dialog to set a password and then save the document without changing the file name.
StuartR
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Password to open setting
Thank you both. Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.