Advice

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
I have a workbook on a public drive

What i would like to do is put a routine in the document which prevents people

* Copying the file
* Deleting the file
* Renaming the file

Is this possible?

TIA
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
You cannot do this in the document. You have to do this using the security permissions on the network. ie they must have read only rights
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
Is there a macro to keep a log of this information such as:

> when deleted, who deleted worrbook etc etc??
 

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
Again you cannot keep a log of this in the workbook. However your network admin should have this data
 

Watch MrExcel Video

Forum statistics

Threads
1,113,794
Messages
5,544,322
Members
410,603
Latest member
rseckler
Top