Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

password protecting a sheet??

password protecting a sheet??

password protecting a sheet??

i am in need of creating aa excell folder with several worksheets. i need to leave at least one with full access by anyone, but also require a password to access some of them, not even read only option...complete
lock-out for several sheets is needed....
thanks in advance....

RE: password protecting a sheet??

If I follow you correctly
You require Permissions on files in a folder.
If so this can only be done on and NTFS partition.
If its a FAT partition it will Passwords are not part of it.
So NTFS partitions are only available on NT workstations and NT servers If they were set up that way.
If the above statements are true

Then contact your Administrator to help you with this.


RE: password protecting a sheet??

DougP... please Slap me.... if I'm being stupid again.... a work around (I know.... I'm very simplistic...) couldn't be to use Two... that's 2 Excel files where you will put your publick worksheet on one of them and the rest of the sheets on the second (making it password protected) and setting up macros or links to open the second one.

All the data could be read from the first one into the second one anyway.....

Like I said.... my brain functions at very basic levels... but it does so... with lots and lots of LUUUUUUUV........

... as always... feel free to insult me at anytime for being so stupid....!

Dumboy.! Ouch.! .my brain.....

It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close