Windows XP question

Argeo · 09-06-2005, 11:02 AM

I have been able to figure out how to protect cells in an Excel spreadsheet but unable to figure out how to keep someone else from deleting or moving the file from the shared drive.

Anyone know how to do this? I greatly would appreciate any advice.

Thanks,

David

id10t · 09-06-2005, 11:05 AM

Windows really doesn't have decent file permissions to deal with this. Best bet would be to put it on a share where you have write access and everyone else only has read access.

dhoward · dhoward's Garage

Tools>protect.
There you have quite a few options to protect what you wish, from individual cells to entire workbooks.

dhoward · dhoward's Garage

Quote:

Originally posted by dhoward
Tools>protect.
There you have quite a few options to protect what you wish, from individual cells to entire workbooks.

Opps. Sorry. Misread.
Nevermind....

Argeo · 09-06-2005, 11:08 AM

Thanks for the response.

Wouldn't people still be able to delete? If someone goes into my current worksheet, they can't change anything without knowing my password. I am just worried about someone deleting the whole file. I could get back but it is a bunch of work for the IT folks.

Thanks again,

David

legion · 09-06-2005, 11:16 AM

You need to work with your IT folks to establish a folder where you have write access and others have read (or no) access.

HardDrive · 09-06-2005, 11:17 AM

You can prevent people from deleting or moving the file by setting the NTFS permission on the document (or the shared folder). Right click the document and select the security tab. Set permissions appropriately (If you need details on this let me know). I am assuming you are the owner of the document.

I don't know squat about excel....

Argeo · 09-06-2005, 11:18 AM

Thanks, I will look into that.

HardDrive · 09-06-2005, 11:19 AM

Quote:

Originally posted by id10t
Windows really doesn't have decent file permissions to deal with this. Best bet would be to put it on a share where you have write access and everyone else only has read access.

What utter BS.

SpeedracerIndy · 09-06-2005, 04:22 PM

Quote:

Originally posted by id10t
Windows really doesn't have decent file permissions to deal with this. Best bet would be to put it on a share where you have write access and everyone else only has read access.

Huh? Where'd you hear that?

Icemaster · Icemaster's Garage

Quote:

Originally posted by id10t
Windows really doesn't have decent file permissions to deal with this. Best bet would be to put it on a share where you have write access and everyone else only has read access.

You're a UNIX admin, right?

SlowToady · 09-06-2005, 04:45 PM

NT ACLs are modeled after OpenVMS ACLs, which are by anyones standards probably the best in the business. MS products may have their shortcomings, but they have darn good ACLs, much better than the standard UNIX protection. It's all about knowing how to use them.