how to protect workbook from deleting

[saqib]

Hi,

I need to protect to workbook from deleting by any other person, any help?

 

[Don]

this is a hard question. You can "save as" the workbook and choose tools
general options to set it up with a passwork and or read only suggested.
But, if you are on a network and another person has access to the folder,
then they could also move or delete that file outside of Excel. If you want
people to see the data but not change, then you could save the excel file in
one place (if you can protect) and save it as something they can not change
like a PDF or know the real one you have and will replace the one viewed by
people over there?

hope this helps

 

[Dave Peterson]

Put the file in a location that that user only has read access to. They won't
be able to change it or delete it.

 

[saqib]

Dear Don,

I appreciate yr help !

so we can say that there is no direct option available in excel which can
protect workbook from deleting by any other user?

one more question, can you temme how can i change the location of backup
file after clicking "always create backup" if i could change the location, i
can keep the backup file to some other drive which would be helpful while
lost original one.

thanks
Saqib

 

[saqib]

Dear Dave,

Thanks for your help,
pls help how can i grant read access to users.

rgds/saqib

 

[Dave Peterson]

Talk to your IT staff. It's usually a Network administrator that does this kind
of thing.