Prevent Viewing on worksheet

[Ellis Yu]

Dear All,

I want to prevent some other one can view some of worksheets in my
workbook. Although Excel can hide the worksheet, it can be unhide again
without protection. Does anyone know how to do so?

Best Rdgs
Ellis

 

[Bruce Sinclair]

Dear All,

I want to prevent some other one can view some of worksheets in my
workbook. Although Excel can hide the worksheet, it can be unhide again
without protection. Does anyone know how to do so?

If you don't want others to see a sheet, don't send it to them - cut it
before you send it to them Anything you protect can be unprotected with
some very handy tools for same.

HTH

 

[Huff]

About the best Excel has to offer is to go into the VBA editor and make
the sheets you want VeryHidden, then password protect the project.

This is still breakable as previous post suggests, but only by a user
who's prepared to spend a bit on a tool or spend ages with a Hex editor
(i.e. not your average user!)

Post back if you want to know how to do the protection.

Thanks

 

[Dave Peterson]

They can also search google to find free tools that will unprotect a workbook in
moments, too.

 

[aaron.kempf]

keep your data in a database.

SHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIITTTTTTTTTTTTTTTTTTTTTTT.

come on kids.. Excel is for babies

 

[Bill Sharpe]

keep your data in a database.

SHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIITTTTTTTTTTTTTTTTTTTTTTT.

come on kids.. Excel is for babies

Aaron
There are password crackers for Access, too!

Bill

 

[dbahooker]

NO THERE ARENT BUDDY.. not one that would let you see the data if it
was properly secured.

keep your data in an Access Data Projects and let the db server keep
track of security

-Aaron

 

[greaseman]

Aaron,

You idiot! Anything can be cracked. Some might take a little longe
to open up, but it's doable.

Where is your head? Up your butt? It must be, with all the crap yo
throw out

 

[dbahooker]

greaseman

what are you going to do.. crack a windows account?

good luck buddy

Excel is for babies. If you don't want people to SEE your data you
should properly secure it in a database

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

what are you going to do.. crack a windows account?

good luck buddy

....

OS accounts may take a little work, but there's always social
engineering.

And all anyone needs to get at any file is physical access to the disk
drive.

 

[aaron.kempf]

not if they use EFS!!!

you're completely off base.

it would take any idiot about 30 seconds to crack an excel vba /
project password... within reason.

it's IMPOSSIBLE to secure.

Databases have _REAL_ security apparatus so that you can assign a
particular group or user read access-- and then you just wouldn't grant
that access to other users.

These Excel dorks are idiots.. Trying to compare the security for Excel
to that of a real database?

Come on kids.. stop using Excel for _EVERYTHING_.

it is impossible to secure.
it is impossible to ensure that people are entering accurate data.
it is impossible to have 2 people entering data inot the same XLS at
the same time.

XL is just a dead end street.


-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

not if they use EFS!!!

....

How many client machines use EFS? How many server machines?

Yes, if one uses file encryption, it becomes difficult to crack (not
impossible, though it make take years to find the key).

you're completely off base.

Not given the prevalence of straight FAT and NTFS file systems in use.

it would take any idiot about 30 seconds to crack an excel vba /
project password... within reason.

it's IMPOSSIBLE to secure.

You're right about that. Excel provides no robust internal security.
OTOH, file open/file modify passwords do provide encryption, and take a
while to crack.

Databases have _REAL_ security apparatus so that you can assign a
particular group or user read access-- and then you just wouldn't grant
that access to other users.

....

What security does Access provide for MDB files?

 

[aaron.kempf]

FAT?

I threw away Fat before I threw away every copy of Windows 95 and 98 i
owned. I mean.. I was an NT user way before 98 came out so who gives a
crap about FAT??

EFS is a requirement for a LOT of companies... it should be a
requirement for every laptop anywhere... I mean seriously-- it should
be a requirement for every laptop anywhere.

MDB files??? who gives a flying **** about MDB?

MDB has been dead for 10 years now. Anybody that tells you otherwise
is an obsolete fucktard.

ADP?
you mean 'gods platform'? It's unbreakable.. and not in the Oracle
sense of the word.

SQL Security is a LOT more secure than this cheesy Excel VBA password.

Sure; with an infinite level of processing power you could brute force
into a SQL authentication box. But you can turn on CL3 auditing and /
or leave SQL authentication outside your db server

but Windows authentication you can't do a goddamn thing about.

I mean.. what are you going to do.. send a couple of bad usernames /
passwords???

guess a couple of passwords?

ADP is unbreakable security wise. That's why Microsoft should make a
flavor of Excel that keeps all the DATA inside of SQL Server.

So that nobody can get to it.

In the day and age when even _Microsoft_ had 80,000 security
'incidents' per quarter-- back in 2004 when I was doing proxy log
analysis??

it's just flat out inexcusable to use Excel for keeping ANY data.

It's not a question of whether it's ok to store email addresses and
financials.

it's not a question of 'just keeping SSN numbers in an extra-secure
domain'.

It's a matter of Excel is a THREAT to each of us.

Keeping data in a portable format-- that isn't really portable in the
first place... is absolutely inexcusable.

not a single cell in Excel should hold data.

It's too goddamn dangerous-- for securty's sake.

I mean seriously here.. how are you going to block home dude from
seeing the data in a workbook?

Will 'veryHiddenWorkbooks' even be protected if I right-click IMPORT a
spreadsheet into a database?

i think that there are some holes there.

the bottom line is that Excel is a security risk-- because have data
emailed around is a waste of time and energy and resource-- and because
it's a risk to email around the WORST TYPE OF DOCUMENT POSSIBLE.

I used to work for this vendor that burned a CD; handed it out at a
conference.. and that CD just happened to have an Excel Workbook on it
that had been compromised.

Norton wasn't detecting it.. so we didn't know about it before hand.

The FACT of the matter is that XLS is _IMPOSSIBLE_ to secure.

And i'd rather use paper and pen than a format that is so dangerous.

 

[Harlan Grove]

(e-mail address removed) wrote...

FAT?

I threw away Fat before I threw away every copy of Windows 95 and 98 i
owned. I mean.. I was an NT user way before 98 came out so who gives a
crap about FAT??

So how many removable media disks have you come across that use NTFS?

EFS is a requirement for a LOT of companies... it should be a
requirement for every laptop anywhere... I mean seriously-- it should
be a requirement for every laptop anywhere.

Maybe it should be a requirement for laptops, but as the linked article
for which you provided the url states, if the key gets corrupted, your
files are effectively as unusable as if you tossed the drive into a
blast furnace. Put a backup copy of the key file onto any removable
media, and you've just taken a big step towards elimintating EFS's
usefulness. Centralized key backup would be a good idea, but not too
helpful when key files get corrupted on the road.

It's a trade-off. As usual, you can't appreciate that.

MDB files??? who gives a flying **** about MDB?

Current spreadsheet users who you presumably want to become Access
users aren't going to be given much access to database servers from the
start. They're going to start off using MDB, not ADP.

MDB has been dead for 10 years now. Anybody that tells you otherwise
is an obsolete fucktard.

....

More obtuse overstatement. 10 years ago Access 95 was the current
version. Since there wasn't any ADP back then, what did Access users
use instead of MDB? DBF files? XLS files? Plain text?

SQL Security is a LOT more secure than this cheesy Excel VBA password. ....

Granted.

It's a matter of Excel is a THREAT to each of us.

To you, perhaps.

Keeping data in a portable format-- that isn't really portable in the
first place... is absolutely inexcusable.

....

So all data should be in XML files? Or are you using your pet
definition of 'portable' meaning SQL Server format?

 

[aaron.kempf]

removable media??

like .... uh floppy discs??

HAHAHAHAHAHA

i haven't used those since my commodore 64... lol.. I threw away maybe
400 disks the day I first saw WIndows 95..

I got tired of walking up the hill in college; trying to copy a
document onto the mac; bringing it home and it never worked.. so i gave
up on those things a LONG ass time ago.

CDroms? DVDs?

I don't use them very often because they're not reliable enough for
ANYTHING.


and my thumbdrive / micro harddrive?

It sure uses NTFS to say the least.


-Aaron

 

[aaron.kempf]

10 years ago; office 97 was the rage wasn't it??

I just remember the fall of 99 I started using ADP.. when office 2000
_FIRST_ came out and I was on a corporate preview program before that.

Sorry 1999 - 2006 is only 7 years huh?

I don't reccomend that ANYONE start out on MDB. MDB is even more
obsolete than XLS.

ADP is BETTER in the longterm, shortterm..

ADP has better training resources-- try to take enterprise level
programming class on MDB lol


Portable documents?? I'm talknig about things like SNAPSHOT-- similiar
to PDF but you dont have to pay for it.

It's included in Access; every version of office (is it my fault that
your IT dept doesnt trust you enough to give you a full install??)

and yeah... shit.. -- of course

_OLAP_

as in Analysis Services-- if you want a report; you bring it up
dynamically... because Olap is fast enough to calculate reports on the
fly... and things are always up to date.

And for the record; i dare you to try to copy an olap cube away from
the server and bring it home.. if you have VPN it works GREAT over a
VPN.. so do Access Data Projects.

Shit i'll run ADP over the public internet for all I care. It works;
it's fast.. lets see you open a XLS from a FTP share; edit it and then
save it... see if that works lol

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

removable media??

like .... uh floppy discs?? ....

Nope.

CDroms? DVDs?

Yup, plus Zip and Jazz drive disks.

I don't use them very often because they're not reliable enough for
ANYTHING.

Except backup?

Like it or not, CD-Rs are the most common removable media currently.

and my thumbdrive / micro harddrive?

....

How many people have Flash drives?

 

[Harlan Grove]

(e-mail address removed) wrote...

10 years ago; office 97 was the rage wasn't it??

....

Wrong again. Math just isn't your forte.

10 years ago from today, Office 97 was more than a year away from its
initial release.

Office 95 may have been the rage in some places, but back then Lotus
SmartSuite still had considerable market share. And more than half of
business PCs were still running Windows 3.1.

Need more history lessons?

Sorry 1999 - 2006 is only 7 years huh?

Very good!

I don't reccomend that ANYONE start out on MDB. MDB is even more
obsolete than XLS.

ADP is BETTER in the longterm, shortterm..

....

And if their IT departments won't give then either create or modify
permissions for the company database servers and their technology
policies don't allow them to install MSDE? How would they use ADP then?

. . . lets see you open a XLS from a FTP share; edit it and then
save it... see if that works lol

It does if you have read AND write permissions on the ftp server. Few
public ftp servers give anyone write permission, and few companies
bother with internal ftp servers.

 

[Huff]

Perhaps we should start up a 'Aaron and Harlon argument' group on
google, and let the pair of you fight it out on there. The rest of us
are getting pretty tired of the pointless argument on whether a
database is better than a spreadsheet or vice-versa. We got a user here
asking a perfectly reasonable question, who could I'm sure do without
13 posts from you two that have no relevance to the user in question.

GIVE UP THE PAIR OF YOU!!!

 

[Harlan Grove]

Huff wrote...
....

GIVE UP THE PAIR OF YOU!!!

Unlikely. Perhaps your time would be better spent learning how to
configure your newsreader to block postings from Aaron and me.