how to protect workbook from deleting

  • Thread starter Thread starter saqib
  • Start date Start date
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
 
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.
 
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
 
Dear Dave,

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

rgds/saqib
 
Talk to your IT staff. It's usually a Network administrator that does this kind
of thing.
 
Back
Top