Hi Vijay,
I think the following code will help to some extent.
Private Sub Workbook_Open()
Application.DisplayAlerts = False
If Range("A1").Value <> "C:\Desktop\[Book2.xls]Sheet1" Then 'In the inverted
please insert the location to chck
MsgBox "Workbook was moved from the Original Location. Hence
Hi Vijay,
Please try the following option:
File--> Permissions --> Do Not Distribute... Once you try this option, excel
will prompt you to download IRM (Information Rights Management) helps
preventing sensitive documents from being forwarded or copied
by unauthorized persons.
However, you can do
Hi all,
Is it possible or not?
regards,
Vijay
On Tue, Apr 27, 2010 at 1:34 AM, Vijay Aggarwal wrote:
> Hi,
>
> I saved a excel file on share drive. I want that everybody can access that
> file but unable to copy that file or data from that file without my
> permission.
>
> Is it possible? If ye
Hi,
I saved a excel file on share drive. I want that everybody can access that
file but unable to copy that file or data from that file without my
permission.
Is it possible? If yes, then tell me how?
Regards,
Vijay
--
---
