Hello Zafar!
I undertood now.
See the attached file, i just added a autosave after opening the file,
See if it works for you
Good luck!
André Luiz D´Avila
2011/4/28 Zafar Iqbal
> Dear Mr. Andre,
>
> Thanks for this help. I observed that this macro will not work if the file
> is closed witho
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
> Za
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
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
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
Incharge Planning
Olaya
