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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

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
 

Forum statistics

Threads
1,141,011
Messages
5,703,725
Members
421,311
Latest member
tanujath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top