Dear Mr. Andre, Thanks for this help. I observed that this macro will not work if the file is closed without SAVE. How to rectify this matter? I request that file should be discarded just after 4 times open independent of Save or No Save. Thanks Regards,
Zafar Iqbal 2011/4/27 André D'Avila <andredavila...@gmail.com> > Zafar, > > I attached a excel file and readapted for your need. > > Just change in my code the "Sheet" and the "collumn" for a less visible one > as possible. > > You can open and save the file for 4 turns only... > > > Good Luck! > > Best Regards > > André Luiz D´Avila > > Em 27 de abril de 2011 16:20, André D'Avila > <andredavila...@gmail.com>escreveu: > > Hey, >> im not an expert but a long time I did something close to what you need... >> >> Each time the file is opened and after the user enable macro security, i >> did a code to write in Plan1 column ZZ line 1 "=now()" >> After save it, the 2 time the user open the file, it writes down the date >> and time in line 2 >> You can make a code to do not open after 4 registers in column zz >> >> I will try to find the file to send you >> >> Best Regards >> >> André Luiz D´Avila >> >> >> 2011/4/27 Zafar Iqbal <ziqba...@gmail.com> >> >>> Dear All, >>> >>> Can someone help in making a macro which will make the Excel file expired >>> after few tries of open & close. For example, file can be opned, saved & >>> closed for four times but this file should not open after 5th time to open. >>> Please help. Thanks >>> Regards, >>> ZAFAR IQBAL >>> >>> ---------------------------------------------------------------------------------- >>> 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/discussexcel >>> >> -- ---------------------------------------------------------------------------------- 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/discussexcel
