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=wall&ref=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=wall&ref=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=wall&ref=ts
