Quote:
Originally Posted by excelledsoftware
When you protected it. What options did you enable? window structure is one of them which may be the reason.
|
Well, to be honest, I don't recall *HOW* I even gave them passwords, so I just saved one and gave a PW to it. Here's what I did:
1)Opened file (before adding PW)
2)Clicked FILE tab on ribbon
3)Clicked SAVE AS
4)Clicked TOOLS drop down (next to SAVE button)
5)Clicked GENERAL OPTIONS
6)There are only 4 choices:
a) ALWAYS CREATE BACKUP check box (not checked)
b) PASSWORD TO OPEN (I entered a PW)
c) PASSWORD TO CLOSE (I entered a PW)
d) READ ONLY RECOMMENDED check box unchecked
I was asked to reenter both passwords, and that was it. I didn't see anyother options. I think there are a couple other ways to protect spreadsheets, but this is the method I used (I am NOT a power user).
Thanx,
Mike