Dear Tem members, can anyone explain me how to protect the code
Regards Shrinivas On Mon, Oct 22, 2012 at 4:44 PM, Shrinivas Shevde <shrinivas...@gmail.com>wrote: > Dear Rajan > Thanks > Regards > Shrinivas > > On Sat, Oct 20, 2012 at 2:53 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > >> * * >> >> *Here are a simplest example,* >> >> * * >> >> *You can use this code to understand the thing about screen updating >> True/False* >> >> * * >> >> *ScreenUpdating is Application Property , so it works on application >> level, means once it set to False then it will be false for every procedure >> until it is not set to TRUE,* >> >> *Try to execute below procedure after and before commenting Third Last >> Line **J*** >> >> * * >> >> *Sub FillByloop()* >> >> * Dim lngI As Long * >> >> * Application.ScreenUpdating = False* >> >> * For lngI = 1 To 10000* >> >> * [a1] = lngI* >> >> * Next* >> >> * Application.ScreenUpdating = True* >> >> * Call FillByloop2* >> >> *End Sub* >> >> * * >> >> * * >> >> *Sub FillByloop2()* >> >> * Dim lngI As Long* >> >> * For lngI = 1 To 10000* >> >> * [a1] = lngI* >> >> * Next * >> >> *End Sub* >> >> * * >> >> *=======================* >> >> *Enjoy **J*** >> >> *=======================* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde >> *Sent:* 20 October 2012 12:01 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$**** >> >> ** ** >> >> Thanks to all**** >> >> Just one question for Knowledge**** >> >> I run the script by both way**** >> >> 1.By Making true at the end**** >> >> 2.Without making true at end**** >> >> I could not notice any difference.**** >> >> So please can any one explain me **** >> >> What is the purpose of making true at end?**** >> >> Aging I ma repeating this is just for Knowledge.**** >> >> **** >> >> Regards**** >> >> Shrinivas**** >> >> On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma <rajanverma1...@gmail.com> >> wrote:**** >> >> *But also make them TRUE at end of code ***** >> >> * ***** >> >> * ***** >> >> *Regards***** >> >> *Rajan verma***** >> >> *+91 7838100659 [IM-Gtalk]***** >> >> * ***** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde >> *Sent:* 19 October 2012 5:25 >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$**** >> >> **** >> >> Dear Both,**** >> >> **** >> >> Very very thanks for solution.**** >> >> **** >> >> Regards**** >> >> Shrinivas**** >> >> On Fri, Oct 19, 2012 at 1:19 PM, <v...@vabs.in> wrote:**** >> >> Hi >> >> Just put Application.Screenupdating = False >> >> Rgds// Vabs **** >> >> **** >> >> Sent on my BlackBerry® from Vodafone**** >> ------------------------------ >> >> *From: *Shrinivas Shevde <shrinivas...@gmail.com> **** >> >> *Sender: *excel-macros@googlegroups.com **** >> >> *Date: *Fri, 19 Oct 2012 12:29:55 +0530**** >> >> *To: *<excel-macros@googlegroups.com>**** >> >> *ReplyTo: *excel-macros@googlegroups.com **** >> >> *Subject: *$$Excel-Macros$$**** >> >> **** >> >> Dear Group member,**** >> >> **** >> >> I wrote small macro which works fine.**** >> >> But when I run macro it shows all action i.e everything ishappening in >> front of user which I dont want .**** >> >> I want that when I run macro Worksheet should be steady and all actions >> should happen at backend.**** >> >> How to do it please let me know.**** >> >> Is ther any extra code needs to write. >> >> -- >> Shrini**** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> **** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> **** >> >> >> >> >> -- >> Shrini**** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> **** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> **** >> >> >> >> >> -- >> Shrini**** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> **** >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > Shrini > -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.