proteced sheet can be edited

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

With respect, I think you didn't understand what I was saying.

I started with this: "Protection in Excel is intended to protect against
inadvertent changes." Now what 'Someone' did to you wasn't inadvertent.
He/she deliberately used a technique to circumvent the protection. By this
stage, the protection had already done what it was intended to do, by not
allowing a change within the sheet itself.

My point is that you shouldn't rely on Excel's protection as you appear to
have done. It sounds like you sent out a workbook and received one back
which you assumed was the same (give or take changes in unprotected cells).
If you choose to do this, you are relying on anyone (not just the intended
recipient) who has had access to the workbook in the meantime.

I understand that further 'security' features have been added to Excel 2002.
I cannot comment in detail as I do not use this version. However, it would
not surprise me in the slightest to find that there are still 'ways around',
like the one you seem to have discovered. I continue to say, just as before,
only rely on protection against INADVERTENT changes.

Something I find intriguing is that there are (in roughly equal numbers)
posts in these newsgroups along one or other of the following lines:
1 "Someone's managed to get around protection in Excel - how awful!"
2 "I've forgotten the password for an Excel file - there must be a way
around this!"
Hmmm!
 
It appears that either the OP does not have the system clock set properly or
is deliberately changing the date to stay on top of the list. I, for one,
delete these. Sorry if you are NOT guilty.
 
Interesting that Mr. "Allmighty" was complaining of one person changing
something in his workbook, while he changed the date on his post
inconveniencing hundreds, if not thousands, of NG readers.

tim
 
Yeah, but I hate AOL...so I will NEVER use Netscape.
OK, maybe if AOL spins off Netscape (like that will ever happen)

Anyway,
I still think the guy is a hypocrite and oughta be strung up from the
highest cubicle.

tim
 
Huh?AOL? If I remember right AOL always used IE browsers up to recently
when they went to Netscapes new build.So now you can't use IE as a
browser either?<G> FYI Mozilla and AOL browsers arent even close in
appearance, think they just liked the new platform Netscape went to.
 
AOL owns Netscape...

tim
Thomas said:
Huh?AOL? If I remember right AOL always used IE browsers up to recently
when they went to Netscapes new build.So now you can't use IE as a
browser either?<G> FYI Mozilla and AOL browsers arent even close in
appearance, think they just liked the new platform Netscape went to.
Click to expand...
 
WTF are you talking about?
Tim Otero said:
Interesting that Mr. "Allmighty" was complaining of one person changing
something in his workbook, while he changed the date on his post
inconveniencing hundreds, if not thousands, of NG readers.

tim

properly
Click to expand...
 
So you basicly say I'm screwed, right?
Anon said:
With respect, I think you didn't understand what I was saying.

I started with this: "Protection in Excel is intended to protect against
inadvertent changes." Now what 'Someone' did to you wasn't inadvertent.
He/she deliberately used a technique to circumvent the protection. By this
stage, the protection had already done what it was intended to do, by not
allowing a change within the sheet itself.

My point is that you shouldn't rely on Excel's protection as you appear to
have done. It sounds like you sent out a workbook and received one back
which you assumed was the same (give or take changes in unprotected cells).
If you choose to do this, you are relying on anyone (not just the intended
recipient) who has had access to the workbook in the meantime.

I understand that further 'security' features have been added to Excel 2002.
I cannot comment in detail as I do not use this version. However, it would
not surprise me in the slightest to find that there are still 'ways around',
like the one you seem to have discovered. I continue to say, just as before,
only rely on protection against INADVERTENT changes.

Something I find intriguing is that there are (in roughly equal numbers)
posts in these newsgroups along one or other of the following lines:
1 "Someone's managed to get around protection in Excel - how awful!"
2 "I've forgotten the password for an Excel file - there must be a way
around this!"
Hmmm!


changes.
Click to expand...
 
Hi
I have this problem with my data. I have data in my sheet that mustn't be
changed i therfor are locke but one cell is unkocked which must be edited.
That all works fine if someone use Office XP but if you use Office 2000 and
down you can CTRL+A and copy it to another sheet where there is no
protection for cells. Is this a bug and can it be solved?
I protect my sheet with password, protect my workbook and I use do not
select locked cells.

Thx in advance
 
You didnt get the point :). Someone edited my sheet with data by this means
and he
shouldnt have and returned it. Whats buging me is thet when you load it in
Exel XP everthing
is fine the cells cant be acessed nor copied, nothing. CTRL+A and copy
doesnt work but in Exel 2000 does. So is it a bug or what? I hope i was
clear in my explanation.
 
allmighty said:
So you basicly say I'm screwed, right?
Click to expand...

Trenchantly put.

Excel's 'security' provides nothing more than modest protection against
INADVERTENT changes. If anyone WANTS to get around it, they can and likely
will. Then again, damn little else does so either. In the past 10 days I
came across an old DOS utility to convert Adobe Acrobat 2.x PDF files into
plain text that works just fine with 4.x PDF files with all the passwords
and other restrictions I could like to put on them. (Don't have Acrobat 5.x
or higher to test them.)

If you give anyone a computer file that can generate readable text on their
monitor, then they can pass screen images through OCR software to reproduce
your file in a completely unprotected form. A nasty little truth about the
digital world: there's NO WAY to protect digital information other than
lawsuits. Just ask the RIAA.
"Anon" <none> wrote in message ....
Click to expand...
....
 
Your posts are/were suspiciously in the future, indicating either you
changed the date on your computer to force your posts to stay at the top of
the listings or you just don't know how to set the clock on your computer.
Either way future posts are annoying to the extreme to most NG users.

tim
 
Back
Top