B
Brad
I want to make the sheet so that it is not viewable by
anyone but myself.
Any help?
Brad
anyone but myself.
Any help?
Brad
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lady Layla
File Save As Tools General Options Put a password in the Password to open
box
Make sure you write down the password so you dont forget it and can get in at a
later date
: I want to make the sheet so that it is not viewable by
: anyone but myself.
: Any help?
: Brad
box
Make sure you write down the password so you dont forget it and can get in at a
later date
: I want to make the sheet so that it is not viewable by
: anyone but myself.
: Any help?
: Brad
B
Bernard Liengme
And anyone can do a Google to find and download a free program to find the
word you used!
word you used!
N
Norman Harker
Hi Bernard!
Re: "And anyone can do a Google to find and download a free program
to find the word you used!"
Is there a method of finding "the" word used? Most approaches find "a"
word that will work. "The" word would be more disturbing bearing in
mind the tendency to use the same password for all sorts of things.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Re: "And anyone can do a Google to find and download a free program
to find the word you used!"
Is there a method of finding "the" word used? Most approaches find "a"
word that will work. "The" word would be more disturbing bearing in
mind the tendency to use the same password for all sorts of things.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
D
Dave Peterson
Ah, but if you typically use THE same word, once I find a word that will work
for one, I'll have the word that will work for all.
for one, I'll have the word that will work for all.
N
Norman Harker
Hi Dave!
The importance of "the" as opposed to "a" is that finding "the"
password will allow use for a multiplicity of nefarious purposes.
Finding "a" password will only work in the context in which the
password was used.
The "word" found by, for example, the AllInternalPasswords subroutine
will be OK for other worksheets in the file and for other workbooks
with internal protection using the same password. But it won't work
for Workbook opening passwords or VBA passwords because they are
different contexts and use a different algorithm.
What AllInternalPasswords does is find a password that has the same
value in Excel's "internal" password algorithm as the "real" password
has. Change algorithm and "the" password will have a different value
from "a" password and won't work.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
The importance of "the" as opposed to "a" is that finding "the"
password will allow use for a multiplicity of nefarious purposes.
Finding "a" password will only work in the context in which the
password was used.
The "word" found by, for example, the AllInternalPasswords subroutine
will be OK for other worksheets in the file and for other workbooks
with internal protection using the same password. But it won't work
for Workbook opening passwords or VBA passwords because they are
different contexts and use a different algorithm.
What AllInternalPasswords does is find a password that has the same
value in Excel's "internal" password algorithm as the "real" password
has. Change algorithm and "the" password will have a different value
from "a" password and won't work.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
D
Dave Peterson
"Excellent" "point" "," "Norman" "." "I" "thought" "that" "you" "were" "saying"
"that" "the" "hashed" "word" "wouldn't" "work" "for" "worksheets" "that" "were"
"protected" "with" "the" "same" "password" "."
"<" "v" "b" "g" ">"
(Well, I thought it was funny!)
"that" "the" "hashed" "word" "wouldn't" "work" "for" "worksheets" "that" "were"
"protected" "with" "the" "same" "password" "."
"<" "v" "b" "g" ">"
(Well, I thought it was funny!)
N
Norman Harker
"R""O""F""L""M""A""O"
Seriously, one trick the JE and I used in AllInternalPasswords was to
find the password for the first protected sheet and then try that on
all other sheets and the (internal) workbook password. That saved
having to start from scratch unless other sheets used different
passwords.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Seriously, one trick the JE and I used in AllInternalPasswords was to
find the password for the first protected sheet and then try that on
all other sheets and the (internal) workbook password. That saved
having to start from scratch unless other sheets used different
passwords.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
D
Dave Peterson
I like that idea. I know I do use the same password to protect different sheets
in a couple of workbooks--but most of my protected worksheets have no
password--a tribute to you and JE!
in a couple of workbooks--but most of my protected worksheets have no
password--a tribute to you and JE!
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.