Hi Prashant
Thanks for ur mail.I think u have a good idea about this issue.I don't
have good knowledge in VBA ,within my limitation what I am doing is
that ,
1) I have a secret file in my computer which have code number , and
all the files which I want prevent coping linked with the secret file.
2) In the macros I wrote a condition for checking the value of the linked cell
If anyone simply copy the file and paste in other the macros will not work.
I think ur way is more reliable, I don't know how to wrote codes in
your ideas. will u give me an example.
Regards Thanks
Rajesh kainikkara
On 1/5/11, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Rajesh,
There is no foolproof method for this.Try to use run security macro
before opening workbook.
Try to do this.To avoid unauthorized use of your workbook.
1.Write the Machine name of Authorized person line by line in notepad
2.Save it with your desirables name
3.Check machine name before opening Workbook/ Else close Workbook.
For any problem to doing this stuff,Send me mail..
Hope it Will Help
On Wed, Jan 5, 2011 at 7:04 PM, Rajesh K R rajeshkainikk...@gmail.com
wrote:
Hi Experts,
Is it possible to prevent coping a particular Excel work book , from
my computer. I am thinking if the macro has an address like computer
name\d\rajesh.xls it will not work in other computer other location
without my permission, I don't know is it possible or is there a
better way for this.
pls write me
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Regards,
Prashant Tripathi
Engineer-SW
Mobile: 0017202597567
Please consider the environment before printing.
Immer zielen auf die vollkommene Harmonie des
Denkens Wort deed.Always zielen darauf ab,
reinigen Sie Ihre Meinung und alles wird gut.
Always aim at complete harmony of thought
word deed.Always aim at purifying your
thoughts everything will be well.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts