I am in the middle of video. Not sure what will be coming next. But Already given a like button. Really good effort to explain in detail. Great effort. Keep up the GOOD work BROTHER.
Few years ago I have searched web for the predefined expiry code and found it. But how it works and a bit easier code has found now. Is it necessary to mention here that I am one of the fans of your clarity and beautiful presentation? 💕
Dear Sir, I became fan of yours because every time my creations get credited to others which is not problem for me at all but if only he/she is the right person to deserve the same. I have some queries Sir, 1. I have followed every step of yours but each time the file opens it automatically changes the date as todays date so, it never get expires but your tutorial said that it will fixed at the time of second time opening the file? pls. help 2. How to restrict the workbook from saving macro-free workbook? 3. If I want to take classes from you what is the procedure and it's better if it is in a recorded format.
Thank you very much indeed. This is really cool. The way you explained is superb. I am sure many people including me will benefit from you. Without hesitation, I subscribed liked and commented. Please upload more
thanks for the explaining in such detail. question. is there a way to put the expiration date in a text file on a web server and then look it up. This would help in cases where once clients pays we can just change the date on our side and the workbook opens again. what would the coding be for this lookup
Awesome Work done learnt a lot. Sir is there any way to open the file if the set expiry date is not changed to another advanced date. Is there any way that we can create for Master Activation Code for the creator of the workbook and user activation code for user, and and if the file is distributed to other person by the one already using it it is set to default use of 10-15 date after that it gets locked and can only be activated by providing the user activation code
Great video and perfect function!!!! As I understand I need to have a copy without this code. Otherwise I cant open it my self after expiration date I tried open the file holding "shift" at the same time but that do not work.
Hi Sir, very informative video and I liked it very much. This video is very useful for me and many others too. By watching your video I also created a expiry code and is working excellent.. thank you very much sir for this video. Just a query sir, if the date goes beyond the expiry date then how to open the workbook? Everytime it keeps on closing
Very informative and easy to understand and follow. The only trouble is that I can't get the date to show in the relevant cell or the message box to appear. Any suggestions please? Please ignore - now working, fault lay somewhere with me!
Thank you Mr, Nabil for this great video! very informative for me , but I wanna ask u sir if I wanna the left days alert pop-up only when the current date near to expire date not far from it. PS , I wanna email u about how to set a password to the vb code . thank you sir,
Well done nice and respectable lesson and also the code is great, only if I may, just say that you can easily bypass the code by changing system time in Windows and then check and see that the workbook has become available again .... I would love if you have a solution available for this, I have Some ideas but with a bit of complex code
Very good work Mr Nabil. But after expiry screen appears then clicking OK. The screen of (save - don't save - cancel) appears. And when I click cancel the file opens. I'm working on office 2019.
Hi - I love your video. I have created an expiry date using the 2nd video example. The only thing I don't want tho is each time you open the spreadsheet it brings up the msgbox saying they have 365 days to use the file. Can a code be added where this only appears once upon opening file and then starts warning them towards the end of the subscription? Like a month out?
Does this work in Excel 2007? I followed all the steps but it doesn't show the message in opening. It show it only manualy when u go to VBA Code and press Run (F5). Thank you in advance!
Thank you very much for sharing this knowledge to us, the rest! It's been very interesting to watch and learn with simple and clear steps! I tried to test my skills in following your steps, as described in your video, in a simple test file of my own, but as soon as I enter VB editor and select This Workbook, I get the message : Variable Uses an automation type not supported in Visual Basic. What's that and what can I do to eliminate it? Thanks a lot and please keep up the great work! Highly Appreciated! "
4 ปีที่แล้ว +1
Hello Thanks for this great video. Is there a way of making something like a licence such that after expiry the sheet can be activated again? I will be glad to hear from you
Glad you liked the video. For your specific work situation you need a consulting service that I DO NOT provide. My time is dedicated to FREE training to Thousands of viewers not to individual work situations. Thanks
Thank you for a great video! Very informative - and just what i needed. I was just wondering if there were any news considering how to force the user to enable macro´s. If i open a expired document without enabling macros i can use it as it was not expired.
Thanks for the tutorial. It is very amazing! Would you show how the owner can open the file after it is expired? and how to password protect the vba code?
That's a very good point. However I can't answer it in a public comment as not to encourage unauthorized access to files. Email me and I'll be glad to answer.
@@Officeinstructor Thanks for your time to look into my question, greatly appreciated. For the vba code to lock the file after it is expired, I know how to set the password to protect the code. However, to open the file with password after it is expired, the file itself has to be opened, so it kind of defeats the purpose of the vba code to lock the file.
I totally understand your point. There is a way to do that but as I said , I cannot write it down here in a public comment. Email me and I will tell you how to do it.
@@Officeinstructor can I get you mail id sir the video was very helpful and I am very thankful to you for sharing this information but after expiry how can a owner open and change the expiry date can you please share that through mail can I get your mail I'd
Great video sir but I am facing a problem that with the increase of date the days of trial is also increasing instead of decreasing and if I decrease the date then the trial version is decreasing suppose 18 March to 19 March trail version becomes 15 days to 16 days and for 18 March to 17 mrach the trial version becomes 15 days to 14 days please help me in solving the issue
I do not know the problem you are facing but I recommend watching the video closely and do not practice on one of your important work files in case you mistakenly lock it
Hi there, I would like to know if it is possible to make an excel file shareable so that multiple users can work in the workbook but not copy-able so the user wont be able to make copies of it.
very nice thanks alot for the video. well my question is i am using code for force the user to turn on the macro . and your code of expiry but it give me error . how to merge these 2 codes ??? they run perfectly independently .. thanks.
the VBA code runs everytime because you’ve have macros enabled in the security options, while actually you have to force the user to enable macro before or the code will not run at all. How to merge the code for a)force the user to enable macro in order to start the vba code b)set the expiration date?
Officeinstructor Thank you for your availability and for your videos. Can’t wait for that video but pls remember in your next video to show how to merge the code for force the user to enable macros in order to run the VBA code for the expiration date. Honestly I got the two different codes but really don’t know how to merge them together..
In the IsEmpty(...), excel does not recognise Range(...). Value = Date.... Gives a complie error for using Date... I guess it should be coz of 64 bit excel... Can u write the code for compatibility as well.. Thanks in advance
Hello Officeinstructor I am from Mongolia. sorry for my bad english i used this code for protecting macro excel template, but if user change the date of computer, then it will be available to use the template. how to solve that?
You are correct, the code reads the computer date. However, You can type a date in a distant cell (whatever you want) and modify your code to compare to that cell.
I did it on my file, but unfortunately it is not opening now due to date over what to do now. Another thing is without micro enable excel file should it possible
What happens if the person is able to open the file since it has not expired but then use the visual basic editor to just remove the expiry date? Thanks.
Is there another option to prevent system date roll-back and execute file. The code you wrote can be tricked by ssytem date roll-back. For instance can you offer a code to retrieve date online so in this case, even system date rolled back this will not affect the execution.
I opened the first file and set the expiry date to yesterday. When the file is opened, i selected option of disable macros. In that case i am still able to open the file.
@@Officeinstructor no doubt code is good, but this is very easy and logical backdoor of this code to change date and open file again........ whats the logic to add this code than?
@@qasimzia7234 let me say a few points: 1- ANY (I repeat ANY) code can be broken at different levels of expertise. 2- There are at least 3 other methods to break this one. But, much more importantly: 3- I am teaching Excel not hacking... building logic and showing VBA functionality... and this goal has been achieved :)
@@Officeinstructor the things i mentioned is not at all related to hacking so please dont mix it. Secondly expiry means expiry, a strong code should not be that much weak technically to restore a thing with a single chnage of clock..... I got your point that you are teaching excel, thats good and highly appreciatedbut i must recommend to change video subject if you thing the logic in your message is valid. Thanks
After expire file close.Then,I can't access VBA.How i'll go vba after expire date. i trying computer date take to previous and this worked for me.But Is there any another method to go vba code.Thanks advanced :)
Please how to renew the expired date again after the excel expired and closed? I set one excel with expire date and I don’t open for long time now it’s closed how to set new expire date again?
@@Officeinstructor thanks a lot sir but still not open I keep press shift key and the massage come and the file close would you make a small video for this ? You are my hero and you are the best teacher I ever seen Mr mourad
Once you open the file you can right click and hide. If you want to hide it so that No One can see it, watch my tutorial th-cam.com/video/451tlvxxWFY/w-d-xo.html
Code (Remember to edit Expiry date before saving) : dim Expiry As date Expiry = "19 July 2020" If Date > expiry then Msgbox "This File has Expired. Please Download new copy.", vbCritical, "File will Close" Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True Application.Quit Else MsgBox "You have " & Expiry-Date & " Day(s) left",vbInformation, "File Expires om " & Expiry End If
@@nibafx I answered this question so many times... It's all about how you press the SHIFT... Use the Open Command IN EXCEL >>> Navigate to the location and select>>before clicking "Open" >> Press and KEEP HOLDING THE SHIFT KEY while clicking open. Do not release the SHIFT until the file opens
Officeinstructor thanks for the answer ! Great video and good explanation, keep doing videos 💛
4 ปีที่แล้ว
@@Officeinstructor hello I need to reach out to you in person via email. If you don't mind kindly share with me your email or email me on mwebazenicholas6@gmail.com and I'll air out my question. Thank you
Can you give me the information how to remove or continue the excel after the excel is expired. Because to edit the date the excel will not open at that condition what we should do
Private Sub Workbook_Open() If IsEmpty(Worksheets(1).Range("A1").Value) = True Then Range("A1").Value = Date End If
Dim Expiry As Date Expiry = Range("A1") + 0 If Date > Expiry Then MsgBox " Corrupt File", vbExclamation, "Repair" Application.DisplayAlerts = False ThisWorkbook.Save Application.DisplayAlerts = True Application.Quit Else MsgBox " Update the File", vbInformation, "Repair" End If End Sub pls check it once where I make mistake.
Thank you for sharing but I need to do the opposite plus it looks like the worksheet when I try to go into the VBA there is a password how do I get this reset and to remove the date code..
![[Full] 4 ต่อ 4 Celebrity EP.920 | 3 พ.ย. 67 | one31](http://i.ytimg.com/vi/KwiW2M_kAg4/mqdefault.jpg)
just in time for this tutorial. since I want to sell my file and I want them to atleast try the file for several days. Thank You
Glad I could help!
But what if client change the expiry date from vb code?? Can we protect code also??
Yes codes can also be protected..there is a part where you can place a password for the code..
Thank you Mr. Nabil , my name is also nabil, i liked your videos and the way you explain , is very simplified.. good luck
I am in the middle of video. Not sure what will be coming next. But Already given a like button. Really good effort to explain in detail. Great effort. Keep up the GOOD work BROTHER.
Thank you for the confidence you put in me. Will do every possible effort to meet your expectations.
Few years ago I have searched web for the predefined expiry code and found it. But how it works and a bit easier code has found now. Is it necessary to mention here that I am one of the fans of your clarity and beautiful presentation? 💕
Thank you my friend... I'm so impressed by your comments on my videos
Very good. I appreciate this video.
Can the owner go back to vba and reopen the file if it is closed? How could that code be written?
Dear Sir, I became fan of yours because every time my creations get credited to others which is not problem for me at all but if only he/she is the right person to deserve the same.
I have some queries Sir,
1. I have followed every step of yours but each time the file opens it automatically changes the date as todays date so, it never get expires but your tutorial said that it will fixed at the time of second time opening the file? pls. help
2. How to restrict the workbook from saving macro-free workbook?
3. If I want to take classes from you what is the procedure and it's better if it is in a recorded format.
Very good elaboration about the topic. It's now become so easy. Thanks man for the tutorial
Glad it helped
Thank you very much indeed. This is really cool. The way you explained is superb. I am sure many people including me will benefit from you. Without hesitation, I subscribed liked and commented. Please upload more
I am thrilled from your comment... It's for people like YOU Frank that I'm doing the hard work... Thank you for the motivation.
How to unlock that file after expiry
thanks for the explaining in such detail. question. is there a way to put the expiration date in a text file on a web server and then look it up. This would help in cases where once clients pays we can just change the date on our side and the workbook opens again. what would the coding be for this lookup
did you ever figure this out? looking to add a check for "the latest version"
Awesome Work done learnt a lot. Sir is there any way to open the file if the set expiry date is not changed to another advanced date. Is there any way that we can create for Master Activation Code for the creator of the workbook and user activation code for user, and and if the file is distributed to other person by the one already using it it is set to default use of 10-15 date after that it gets locked and can only be activated by providing the user activation code
Great video and perfect function!!!!
As I understand I need to have a copy without this code. Otherwise I cant open it my self after expiration date
I tried open the file holding "shift" at the same time but that do not work.
What a great way to teach us Thank You sir . but 2 Questions how can we recover expired Workbook and how can we force user to enable macros.?
Hi Sir, very informative video and I liked it very much. This video is very useful for me and many others too. By watching your video I also created a expiry code and is working excellent.. thank you very much sir for this video.
Just a query sir, if the date goes beyond the expiry date then how to open the workbook? Everytime it keeps on closing
Press and keep holding the SHIFT key while opening the file, to bypass the code (Keep it as a secret)
Very informative and easy to understand and follow. The only trouble is that I can't get the date to show in the relevant cell or the message box to appear. Any suggestions please? Please ignore - now working, fault lay somewhere with me!
Really cool... and of course don't forget to protect your vba code with a password...!!!
You are totally right Ivan, thank you.
Love your videos. That's what I was looking for ❤❤❤
Thank you Mr, Nabil for this great video! very informative for me , but I wanna ask u sir if I wanna the left days alert pop-up only when the current date near to expire date not far from it.
PS , I wanna email u about how to set a password to the vb code .
thank you sir,
Thank you very much 😊. And at the end , what did you pressed to improve the code appearance??
Fantastic, it worked Great
I have one challenge that anyone whom i share can also go and change the vb code and extend the trail. How to prevent that?
very much clearly explained. very informative. thank you.
You are welcome!
Well done nice and respectable lesson and also the code is great, only if I may, just say that you can easily bypass the code by changing system time in Windows and then check and see that the workbook has become available again .... I would love if you have a solution available for this, I have Some ideas but with a bit of complex code
Very good work Mr Nabil. But after expiry screen appears then clicking OK. The screen of (save - don't save - cancel) appears. And when I click cancel the file opens. I'm working on office 2019.
Awesome ! Thank you so much. Is there a way to make the file read-only after a set date instead of locking out?
Hi - I love your video. I have created an expiry date using the 2nd video example. The only thing I don't want tho is each time you open the spreadsheet it brings up the msgbox saying they have 365 days to use the file. Can a code be added where this only appears once upon opening file and then starts warning them towards the end of the subscription? Like a month out?
Excellent tutorial!
Does this work in Excel 2007?
I followed all the steps but it doesn't show the message in opening. It show it only manualy when u go to VBA Code and press Run (F5).
Thank you in advance!
Thank you very much for sharing this knowledge to us, the rest! It's been very interesting to watch and learn with simple and clear steps!
I tried to test my skills in following your steps, as described in your video, in a simple test file of my own, but as soon as I enter VB editor and select This Workbook, I get the message : Variable Uses an automation type not supported in Visual Basic. What's that and what can I do to eliminate it? Thanks a lot and please keep up the great work! Highly Appreciated! "
Hello
Thanks for this great video.
Is there a way of making something like a licence such that after expiry the sheet can be activated again? I will be glad to hear from you
Glad you liked the video.
For your specific work situation you need a consulting service that I DO NOT provide.
My time is dedicated to FREE training to Thousands of viewers not to individual work situations. Thanks
You are Genius Dear , Sir.
Thank you for a great video! Very informative - and just what i needed. I was just wondering if there were any news considering how to force the user to enable macro´s. If i open a expired document without enabling macros i can use it as it was not expired.
Thanks for the tutorial. It is very amazing! Would you show how the owner can open the file after it is expired? and how to password protect the vba code?
That's a very good point. However I can't answer it in a public comment as not to encourage unauthorized access to files. Email me and I'll be glad to answer.
@@Officeinstructor Thanks for your time to look into my question, greatly appreciated. For the vba code to lock the file after it is expired, I know how to set the password to protect the code. However, to open the file with password after it is expired, the file itself has to be opened, so it kind of defeats the purpose of the vba code to lock the file.
I totally understand your point. There is a way to do that but as I said , I cannot write it down here in a public comment. Email me and I will tell you how to do it.
@@Officeinstructor can I get you mail id sir the video was very helpful and I am very thankful to you for sharing this information but after expiry how can a owner open and change the expiry date can you please share that through mail can I get your mail I'd
@@Officeinstructor hi sir pls can i get your E-mail account
Great video sir but I am facing a problem that with the increase of date the days of trial is also increasing instead of decreasing and if I decrease the date then the trial version is decreasing suppose 18 March to 19 March trail version becomes 15 days to 16 days and for 18 March to 17 mrach the trial version becomes 15 days to 14 days please help me in solving the issue
I do not know the problem you are facing but I recommend watching the video closely and do not practice on one of your important work files in case you mistakenly lock it
Hi there, I would like to know if it is possible to make an excel file shareable so that multiple users can work in the workbook but not copy-able so the user wont be able to make copies of it.
I MIGHT BE CREATING A VIDEO ON THIS ISSUE IN THE FUTURE
Great explanation! Thank you for all the details...
This was awesome.. Hope to see more of it:)
Glad you like it.
I invite you to Watch my new tutorials
very nice thanks alot for the video.
well my question is i am using code for force the user to turn on the macro . and your code of expiry but it give me error . how to merge these 2 codes ??? they run perfectly independently ..
thanks.
I added .... Expiry = "16 May 2019"..., but upon opening the error message: run-time error 13 / Type mismatch. Do I need to change the date format?
Very Useful Tutorial.👍
Can This Expired File Be Recovered?
Yes it can... but by regular techniques
Please,
Give Me A Tutorial On This Topic.
the VBA code runs everytime because you’ve have macros enabled in the security options, while actually you have to force the user to enable macro before or the code will not run at all. How to merge the code for a)force the user to enable macro in order to start the vba code b)set the expiration date?
Great point. I will create a special video to answer your important question on how to force the user to enable macros. Stay tuned
Officeinstructor Thank you for your availability and for your videos. Can’t wait for that video but pls remember in your next video to show how to merge the code for force the user to enable macros in order to run the VBA code for the expiration date.
Honestly I got the two different codes but really don’t know how to merge them together..
i am also stuck with same problem. i want to these both macro work. but it give me error. please if u find the fix please let me know aswell
Without enabling macro file, how I will do it.
@@Officeinstructor is the video on forcing the user to enable macro already available?
In the IsEmpty(...), excel does not recognise Range(...). Value = Date.... Gives a complie error for using Date... I guess it should be coz of 64 bit excel... Can u write the code for compatibility as well.. Thanks in advance
Hello Officeinstructor
I am from Mongolia. sorry for my bad english
i used this code for protecting macro excel template, but if user change the date of computer, then it will be available to use the template. how to solve that?
You are correct, the code reads the computer date. However, You can type a date in a distant cell (whatever you want) and modify your code to compare to that cell.
@@Officeinstructor Thanks for replying. i dont know VBA code, and also dont know how to make code for setting expiration with date on certain cell
It worked great. But when i use it on google sheets, person can use it after expiry date also
Sorry, I teach Excel not Google sheets.
I did it on my file, but unfortunately it is not opening now due to date over what to do now. Another thing is without micro enable excel file should it possible
You can disable the code by consistently pressing SHIFT while the file is opening
Superb explanation
What happens if the person is able to open the file since it has not expired but then use the visual basic editor to just remove the expiry date? Thanks.
We apply protection to the VB editor so that it requires password.
Is there another option to prevent system date roll-back and execute file. The code you wrote can be tricked by ssytem date roll-back. For instance can you offer a code to retrieve date online so in this case, even system date rolled back this will not affect the execution.
I opened the first file and set the expiry date to yesterday. When the file is opened, i selected option of disable macros. In that case i am still able to open the file.
If you press SHIFT while opening the file , it will still open without disabling Macros
Hi Nabil,
It a good presentation. How to protect the code from viewers?
Thanks for your reply in advance.
Protect the code itself by going to its properties
Nice amazing Vdo sir.... i have tried the expired file not open ...try is continuee...
Press and keep holding SHIFT while opening the File
I downloaded the excel file but there is no code there.
Is it possible the date change in days because you change the your systems date so expiry date will exceed easily.
Yes the code reads the computer date... changing it bypasses the code
@@Officeinstructor no doubt code is good, but this is very easy and logical backdoor of this code to change date and open file again........ whats the logic to add this code than?
@@qasimzia7234 let me say a few points:
1- ANY (I repeat ANY) code can be broken at different levels of expertise.
2- There are at least 3 other methods to break this one. But, much more importantly:
3- I am teaching Excel not hacking... building logic and showing VBA functionality... and this goal has been achieved :)
@@Officeinstructor the things i mentioned is not at all related to hacking so please dont mix it.
Secondly expiry means expiry, a strong code should not be that much weak technically to restore a thing with a single chnage of clock.....
I got your point that you are teaching excel, thats good and highly appreciatedbut i must recommend to change video subject if you thing the logic in your message is valid.
Thanks
If macros are disabled by IT officer how to make it work?
After expire file close.Then,I can't access VBA.How i'll go vba after expire date. i trying computer date take to previous and this worked for me.But Is there any another method to go vba code.Thanks advanced :)
what happen If I change the PC system date backward, and will the expired worksheet be workable again ?
YES
@@Officeinstructor OMG, this is the biggest secret on Earth then !!!
Is it possible to set an expiration date without giving the client/user the widow warning of the time remaining?
Sure... Just remove the line of the message box
Awesome Great work
Thanks a lot 😊
sir i want apply on my excel but not able help me
I've tried your script but when I tried to used previous date it would still function
how to make it both ways, you cannot used it using previous date
Thank you this helped me a loot!
Please how to renew the expired date again after the excel expired and closed?
I set one excel with expire date and I don’t open for long time now it’s closed how to set new expire date again?
Press and keep holding SHIFT while you open the file to bypass the code.
@@Officeinstructor thanks a lot sir but still not open I keep press shift key and the massage come and the file close would you make a small video for this ?
You are my hero and you are the best teacher I ever seen Mr mourad
thanks for this sir..
Most welcome
but is there a way that only the expired file will close and not all excel workbooks running.
You may replace
Application.Quit
by
ThisWorkbook.close
@@Officeinstructor Thank you. I was afraid that the user would accidentally close other workbooks and not being able to save them.
i got the code thanks a lot will b in touch with u for further help
How to delete the file automatically after expiry date _/\_ please someone help
Sir how can one hide specific sheets after that
Once you open the file you can right click and hide. If you want to hide it so that No One can see it, watch my tutorial
th-cam.com/video/451tlvxxWFY/w-d-xo.html
i downloaded the file but could not find the code
i got the code ,will be touch with u thanks a lot
Great 👍
Code (Remember to edit Expiry date before saving) :
dim Expiry As date
Expiry = "19 July 2020"
If Date > expiry then
Msgbox "This File has Expired. Please Download new copy.", vbCritical, "File will Close"
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
Application.Quit
Else
MsgBox "You have " & Expiry-Date & " Day(s) left",vbInformation, "File Expires om " & Expiry
End If
Thanks for sharing
Thank you ..
You're welcome
helppppp~ how to do this in ppt file?????????
someone who solve the issue of bypass the expired workbook to edit the code again ?? help please
Press SHIFT while opening the file to bypass the code
@@Officeinstructor thanks for answer. I press shift but it didn't work, why can it be ?
@@nibafx I answered this question so many times... It's all about how you press the SHIFT...
Use the Open Command IN EXCEL >>> Navigate to the location and select>>before clicking "Open" >> Press and KEEP HOLDING THE SHIFT KEY while clicking open. Do not release the SHIFT until the file opens
Officeinstructor thanks for the answer ! Great video and good explanation, keep doing videos 💛
@@Officeinstructor hello
I need to reach out to you in person via email. If you don't mind kindly share with me your email or email me on mwebazenicholas6@gmail.com and I'll air out my question. Thank you
Can you give me the information how to remove or continue the excel after the excel is expired. Because to edit the date the excel will not open at that condition what we should do
Did you read the video description? I don't think so.
Compile Error Found
Review your code character by character and space by space
Private Sub Workbook_Open()
If IsEmpty(Worksheets(1).Range("A1").Value) = True Then
Range("A1").Value = Date
End If
Dim Expiry As Date
Expiry = Range("A1") + 0
If Date > Expiry Then
MsgBox " Corrupt File", vbExclamation, "Repair"
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
Application.Quit
Else
MsgBox " Update the File", vbInformation, "Repair"
End If
End Sub
pls check it once where I make mistake.
Thank you for sharing but I need to do the opposite plus it looks like the worksheet when I try to go into the VBA there is a password how do I get this reset and to remove the date code..