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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

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,176,367
Messages
5,902,732
Members
434,990
Latest member
Peter Jeffrey Gale

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