Re: $$Excel-Macros$$ Error in Excel-VB macro
But, yes workbook is password protected, but earlier it doesn't gives error, but now when I am opening workbook it gives error for debug. On Mon, May 9, 2016 at 7:31 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > The problem seems to be that some protection flag for the workbook is set. > I'm using Excel 2010, and for some reason, on the Review tab, the Protect > Workbook icon doesn't SHOW that it is protected. > But I protected the workbook (with password) and then unprotected it. > > After that, the macros work correctly. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > --------- > > > On Monday, May 9, 2016 9:09 AM, ITP Abdulgani Shaikh < > itpabdulg...@gmail.com> wrote: > > > > I want to make sure that macro is enable in excel sheet, but it gives > error. > > Please guide. > > > > -- > Shaikh AbdulGani A R > ITP, STP, TRP, STRP > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Giving error in renaming sheet using VBA
Thanks Sharmaji, On Sat, May 16, 2015 at 4:45 PM, Pankaj Sharma pankaj123...@gmail.com wrote: Done!!! Regards Pankaj Sharma *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh *Sent:* Saturday, May 16, 2015 12:16 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Giving error in renaming sheet using VBA I have used VBA Code for renaming sheet, (by pressing Rename button), but it gives error, what goes wrong ? -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Macro should not create new sheet without complete data fill in existing
Sharmaji perfect !! Thanks can we add one more condition i.e. Cell value of O19 should not be greater than W30 ? On Tue, May 12, 2015 at 10:39 AM, Titu Sharma niks...@gmail.com wrote: try below in your add code, If Range(I2).Value = Or Range(L2).Value = Or Range(V1).Value = Or Range(V2).Value = Then Exit Sub End If On Tue, May 12, 2015 at 9:29 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Thanks for your reply. Let me explain again. This sheet will be used to calculate Income-tax to be deducted from Salary of each employee. When data entry in Master sheet is done, and user want to create another new sheet for next employee by creating Add button given on sheet, it should not create until data in RED colour NOT filled. In short RED marked filled are mandatory filled and user should not move or create new sheet until and unless he filled data in it. Regards -- Regards, Titu Sharma +919990053941 -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Want to disable copy, cut paste
but how ? On Fri, Feb 13, 2015 at 1:41 PM, Vaibhav Joshi v...@vabs.in wrote: You can protect sheet/wb and disable cut/copy /paste.. On Fri, Feb 13, 2015 at 11:50 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: I want to disable copy, cut paste in the attached file. And I also request If Copy, cut paste is disable in this file, it should not disable it in other files on my PC. Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Want to disable copy, cut paste
Thanks Vaibhav, I will go through it. On Fri, Feb 13, 2015 at 5:00 PM, Vaibhav Joshi v...@vabs.in wrote: check this.. https://support.office.microsoft.com/en-in/article/Password-protect-worksheet-or-workbook-elements-dbf706e0-ba22-4a08-84d8-552db16eef11?CorrelationId=b2f7131e-60c0-41ba-bb69-80f6b34ed775ui=en-USrs=en-INad=IN On Fri, Feb 13, 2015 at 3:48 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: but how ? On Fri, Feb 13, 2015 at 1:41 PM, Vaibhav Joshi v...@vabs.in wrote: You can protect sheet/wb and disable cut/copy /paste.. On Fri, Feb 13, 2015 at 11:50 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: I want to disable copy, cut paste in the attached file. And I also request If Copy, cut paste is disable in this file, it should not disable it in other files on my PC. Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ Re: Want to disable copy, cut paste
Thanks Michael, I will go through it and will update. On Sat, Feb 14, 2015 at 1:38 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Abdulgani, Please check this.. http://www.asap-utilities.com/excel-tips-detail.php?categorie=9m=85 On Friday, February 13, 2015 at 11:51:05 AM UTC+5:30, ITP Abdulgani wrote: I want to disable copy, cut paste in the attached file. And I also request If Copy, cut paste is disable in this file, it should not disable it in other files on my PC. Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ If cell is blank, it should give error msg
Yes got it, but active sheet is password protected, any solution for that. On Tue, Sep 10, 2013 at 8:29 PM, De Premor d...@premor.net wrote: If you want to select current sheet, Use* ActiveSheet *to select it, not ActiveWorkbook *ActiveSheet*.Unprotect bla...bla...bla... *ActiveSheet*.Protect Pada 10/09/2013 21:52, ITP Abdulgani Shaikh menulis: Dear Sir, This sheet is again giving problem, please see attachments. When I am additing sheet and running CHECK macro, it gives error on new added sheet. Regards On Wed, Sep 4, 2013 at 10:24 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Thnks its working fine. Can you do something for 2 issue, I know it require lil bit time Or do partly guide me, i will try for it Once again thnks On Sep 2, 2013 7:16 PM, De Premor d...@premor.net wrote: Ups Sorry, i've forgot a line code for unlocking you sheet protection See at Line 4 and last line that i've bold Sub check() Dim Birth As Range, PANo As Range, UserInput, Arr Set Birth = [G2] Set PANo = [j2] *Sheet5.Unprotect *If IsEmpty(Birth) Then Birth.Interior.Color = 255 Birth.Interior.Pattern = xlSolid If MsgBox(Birth Date is empty, Do you want to enter data now ?, vbYesNo + vbQuestion) = vbYes Then UserInput = Application.InputBox(Enter the Bith Date using format DD/MM/, Birth Date, Type:=2) If Not UserInput = False Then Arr = Split(UserInput, /) Birth.Formula = =DATE( Arr(2) , Arr(1) , Arr(0) ) Birth.Interior.Pattern = xlNone End If End If End If If IsEmpty(PANo) Then PANo.Interior.Color = 255 PANo.Interior.Pattern = xlSolid If MsgBox(PANo is empty, Do you want to enter data now ?, vbYesNo + vbQuestion) = vbYes Then UserInput = Application.InputBox(Input PANo !, PANo, Type:=1) If Not UserInput = False Then PANo = UserInput PANo.Interior.Pattern = xlNone End If End If End If *Sheet5.Protect** *End Sub Pada 02/09/2013 20:05, ITP Abdulgani Shaikh menulis: Thank you for your response, but it gives error as, pl find attached file. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page
Re: $$Excel-Macros$$ If cell is blank, it should give error msg
Yes, working fine. Can you please explain me Birth.Interior.Pattern = xlSolid PANo.Interior.Pattern = xlSolid and when we are entering Birthdate using other than / it gives error, instead of debug error, can we put error message. Regards On Tue, Sep 10, 2013 at 8:48 PM, De Premor d...@premor.net wrote: If you sheet protected by a password, you can add a password on next statement Before doing some change on sheet, add this line ActiveSheet.Unprotect MySheetPassword and after done with it, lock it again by using the same password ActiveSheet.Protect MySheetPassword Pada 10/09/2013 22:09, ITP Abdulgani Shaikh menulis: Yes got it, but active sheet is password protected, any solution for that. On Tue, Sep 10, 2013 at 8:29 PM, De Premor d...@premor.net wrote: If you want to select current sheet, Use* ActiveSheet *to select it, not ActiveWorkbook *ActiveSheet*.Unprotect bla...bla...bla... *ActiveSheet*.Protect Pada 10/09/2013 21:52, ITP Abdulgani Shaikh menulis: Dear Sir, This sheet is again giving problem, please see attachments. When I am additing sheet and running CHECK macro, it gives error on new added sheet. Regards On Wed, Sep 4, 2013 at 10:24 AM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Thnks its working fine. Can you do something for 2 issue, I know it require lil bit time Or do partly guide me, i will try for it Once again thnks On Sep 2, 2013 7:16 PM, De Premor d...@premor.net wrote: Ups Sorry, i've forgot a line code for unlocking you sheet protection See at Line 4 and last line that i've bold Sub check() Dim Birth As Range, PANo As Range, UserInput, Arr Set Birth = [G2] Set PANo = [j2] *Sheet5.Unprotect *If IsEmpty(Birth) Then Birth.Interior.Color = 255 Birth.Interior.Pattern = xlSolid If MsgBox(Birth Date is empty, Do you want to enter data now ?, vbYesNo + vbQuestion) = vbYes Then UserInput = Application.InputBox(Enter the Bith Date using format DD/MM/, Birth Date, Type:=2) If Not UserInput = False Then Arr = Split(UserInput, /) Birth.Formula = =DATE( Arr(2) , Arr(1) , Arr(0) ) Birth.Interior.Pattern = xlNone End If End If End If If IsEmpty(PANo) Then PANo.Interior.Color = 255 PANo.Interior.Pattern = xlSolid If MsgBox(PANo is empty, Do you want to enter data now ?, vbYesNo + vbQuestion) = vbYes Then UserInput = Application.InputBox(Input PANo !, PANo, Type:=1) If Not UserInput = False Then PANo = UserInput PANo.Interior.Pattern = xlNone End If End If End If *Sheet5.Protect** *End Sub Pada 02/09/2013 20:05, ITP Abdulgani Shaikh menulis: Thank you for your response, but it gives error as, pl find attached file. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever
Re: $$Excel-Macros$$ If cell is blank, it should give error msg
Thnks its working fine. Can you do something for 2 issue, I know it require lil bit time Or do partly guide me, i will try for it Once again thnks On Sep 2, 2013 7:16 PM, De Premor d...@premor.net wrote: Ups Sorry, i've forgot a line code for unlocking you sheet protection See at Line 4 and last line that i've bold Sub check() Dim Birth As Range, PANo As Range, UserInput, Arr Set Birth = [G2] Set PANo = [j2] *Sheet5.Unprotect *If IsEmpty(Birth) Then Birth.Interior.Color = 255 Birth.Interior.Pattern = xlSolid If MsgBox(Birth Date is empty, Do you want to enter data now ?, vbYesNo + vbQuestion) = vbYes Then UserInput = Application.InputBox(Enter the Bith Date using format DD/MM/, Birth Date, Type:=2) If Not UserInput = False Then Arr = Split(UserInput, /) Birth.Formula = =DATE( Arr(2) , Arr(1) , Arr(0) ) Birth.Interior.Pattern = xlNone End If End If End If If IsEmpty(PANo) Then PANo.Interior.Color = 255 PANo.Interior.Pattern = xlSolid If MsgBox(PANo is empty, Do you want to enter data now ?, vbYesNo + vbQuestion) = vbYes Then UserInput = Application.InputBox(Input PANo !, PANo, Type:=1) If Not UserInput = False Then PANo = UserInput PANo.Interior.Pattern = xlNone End If End If End If *Sheet5.Protect** *End Sub Pada 02/09/2013 20:05, ITP Abdulgani Shaikh menulis: Thank you for your response, but it gives error as, pl find attached file. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Indian Salary TDS calculator for FY 2013-14
I have shared this file to be used by excel users for the purpose of calculating Income-tax on Salary. It will be highly appreciated if somebody could suggest me, how can it be made more userfriendly from EXCEL point of view. I have taken care of provisions of tax laws, just need suggestions from EXCEL point of view. Regards On Thu, Aug 22, 2013 at 2:17 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Excel Masters, Please find attached herewith Salary TDS calculator for FY 2013-14. I am not expert in VB, but just tried to make this sheet namely *MASTER* more useful to all users. Is this OK ? Please suggest any idea to make it more user friendly. Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Sortring out worksheets in ascedning order
Gr8, can please tell me, if I want to ignore first two sheet while sorting ascending or descending. How to do it ? On Fri, May 24, 2013 at 4:50 PM, Abhishek Jain abhishek@gmail.comwrote: Check this. On Fri, May 24, 2013 at 4:38 PM, Prabhakar S H prabakar.k...@gmail.comwrote: Hi Team, Plese check and tell me is it possible to sor out work sheets in ascending order. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ How to create hyperlink within workbook
I have created hyperlink, using formula but it is not working, whats going wrong ? I want to create hyperlink within workbook, that workbook will be used by different people on different server. Please guide. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ INCOME TAX HELP
also you will find people doing job like this on www.incometaxindia.gov.inLOCATE TRP section and www.trpscheme.com On Fri, Jun 1, 2012 at 2:32 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: Dear Mr Tarun, This is already discussed in this forum. You will find free utilities available on NSDL website on following link : https://www.tin-nsdl.com/etds-etcs/eTDS-download-regular.php Regards On Fri, Jun 1, 2012 at 1:58 PM, Anil Gawli gawlianil8...@gmail.comwrote: pls give me the output of the report, means it will give me idea to create. Regards, Gawli Anil On Fri, Jun 1, 2012 at 1:01 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: Sir , please try to solve my problem...i want to calulate income tax of around 300 employees and want to create quarterly return report , annual return report and form 16 using excel and print out facility should be in it...please help. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- 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
Re: $$Excel-Macros$$ Introduce Yourself !!
Sorry for late. Myself Shaikh AbdulGani A.R., working as Taxation Manager also practicing as Tax Consultant in field of Income-tax, TDS and MH VAT. This group helped me a lot for making lot of templates for smooth working. Regard On Wed, Jun 13, 2012 at 3:47 PM, Tinusz Tamás ta...@tinusz.hu wrote: Hi all, Name : *Tamás TINUSZ* * * gender: male Age : 47 Current City : Budapest (Hungary / Europe) Job: Customer Service – Office Leader in Waterworks Experience : ~25Years Facebook: https://www.facebook.com/tinusz.tamas Interest : Excel Formulas, VBA, tipps tricks.. Mobile : +36204227400 ** ** Thanking You ** ** *Tamás* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain *Sent:* Friday, June 08, 2012 9:22 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Introduce Yourself !! ** ** Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans!* *** I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ INCOME TAX HELP
Dear Mr Tarun, This is already discussed in this forum. You will find free utilities available on NSDL website on following link : https://www.tin-nsdl.com/etds-etcs/eTDS-download-regular.php Regards On Fri, Jun 1, 2012 at 1:58 PM, Anil Gawli gawlianil8...@gmail.com wrote: pls give me the output of the report, means it will give me idea to create. Regards, Gawli Anil On Fri, Jun 1, 2012 at 1:01 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: Sir , please try to solve my problem...i want to calulate income tax of around 300 employees and want to create quarterly return report , annual return report and form 16 using excel and print out facility should be in it...please help. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Poem- Happy Birthday Ayush...........
Fantastic, Noorainbhai, Wish you many many belated happy birthday Ayush, you have really done good job by creating this group Regards 2012/4/26 bhupendra singh raghav raghav.bhupen...@gmail.com Kyaa bat hai noorian bhai... On Thu, Apr 26, 2012 at 9:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: हरदम हँसते मुस्कुराते रहे,ना रहे कभी मायुश बाबु. गम ना आये आपके जीवन में, रहे सदा खुश बाबु. जन्मदिन की बहूत-२ बधाई Group के ओर से आयुष बाबु. दुआ हमारी है की आप जिए हजारों साल तक. आपकी प्रसिद्धि की चर्चा हो धरती से पाताल तक. सफलता आपकी क़दमों को चूमे हजारों बार. बना रहे सदा आप पर लक्ष्मी जी का उपकार. यूँही खूब घूमे लन्दन,पेरिस, कनाडा और रूस बाबु. जन्मदिन की बहूत-२ बधाई Group के ओर से आयुष बाबु. आपकी सारी मुश्किलें खुशियों से कर ले यथाशीघ्र संधि. आप से हर मोड़ पे मात खाए, आपके सारे प्रतिद्वंदी. बदले जाए चाहे निजाम, ज़मी से आसमान का. मगर कायम रहे रिश्ता आपके होंठों से मुश्कान का. LUCK हर कंदम पे करती रहे आपके मेहनत को PUSH बाबु. जन्मदिन की बहूत-२ बधाई Group के ओर सेआयुष बाबु. -- Thanks regards, Noorain Ansari www.noorainansari.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Block cell editing
I am new to this, can you please explain in detail how to do this Regards On Tue, Apr 24, 2012 at 2:47 PM, CoRe neculae.vale...@gmail.com wrote: Hello Rd In the Review tab , Protect Workbook/Structure , create a password , after in the same tab go on Protect Sheet create a password and it is done. On Tuesday, April 24, 2012 12:03:51 PM UTC+3, Rd wrote: I ant to block cell editing or editing a sheet without using a password in the sheet, can u please help me out with the codes On Tuesday, April 24, 2012 12:03:51 PM UTC+3, Rd wrote: I ant to block cell editing or editing a sheet without using a password in the sheet, can u please help me out with the codes -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Fwd: $$Excel-Macros$$ INCOME TAX SOFTWARE
Dear Tarun I have found this one made by Mr.Pranab, please get is verified before using it. I have not made this, but found useful to you. If you are having large no.of employees for whom you need this, always buy software or ask professionals to do this job. Free excel utility will not do much for large requirement. If you want I will do it for you. Regards On Fri, Apr 20, 2012 at 6:40 PM, Shekhar Sharma shekhar1...@gmail.comwrote: For that you have to google the available softwares and their functionality. Regards Shekhar Sharma On Fri, Apr 20, 2012 at 6:23 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: sir, i want a income tax calculating software using excel bywhich i can calculate tax and take return querterly and annualy and the form 16 will be automatically generated and i can take print out of that.please help. -- With Regards .. Tarun Mondal -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ If date in One then another cell to be unlock
Thanks a lot Sir, I am updating my sheets and will get back to you. Regards On Sun, Apr 15, 2012 at 10:13 PM, dguillett1 dguille...@gmail.com wrote: If your request is for a reply, I did reply. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Abdulgani Shaikh itpabdulg...@gmail.com *Sent:* Saturday, April 14, 2012 5:18 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock Pl.reply On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, You can try this : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = $C$3 Then Me.Unprotect If Target.Value = 0 Or Len(Target.Value) = 0 Then Range(E3).Locked = False Else Range(E3).Locked = True End If End If Me.Protect End Sub *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh *Sent:* Apr/Sat/2012 12:23 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. Regards -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ If date in One then another cell to be unlock
I have pasted it in worksheet code module, but it is not working, pl tell me where I am wrong ? File is attached herewith. Regards On Sun, Apr 15, 2012 at 8:52 AM, Rajan_Verma rajanverma1...@gmail.comwrote: You need to paste it in worksheet code module. ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Abdulgani Shaikh *Sent:* Apr/Sat/2012 02:03 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock ** ** I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards ** ** On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi, You can try this : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = $C$3 Then Me.Unprotect If Target.Value = 0 Or Len(Target.Value) = 0 Then Range(E3).Locked = False Else Range(E3).Locked = True End If End If Me.Protect End Sub *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh *Sent:* Apr/Sat/2012 12:23 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. Regards -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock
My sheet contains some tax formula and I want to keep these formula protected, if inadvertently they deleted or corrected, it will not give correct answer. If I am protecting the worksheet, it gives error at Range(A1:J58).SpecialCells(xlCellTypeConstants, 1).ClearContents Please guide Thanks a lot for everything, that's what I want really. Regards On Sat, Apr 14, 2012 at 8:34 PM, dguillett1 dguille...@gmail.com wrote: On your protection, why not just leave unprotected... On your macros, see attached (Sent direct to OP) ‘--- Option Explicit Sub AddSheetSAS() ActiveWorkbook.Save Dim i As Long Dim s, k As String s = InputBox(Please Enter INITIALs of Employee as Sheet Name to be added) For i = 1 To Worksheets.Count k = Worksheets(i).Name If UCase(k) = UCase(s) Then MsgBox Sheet Already Exists Exit Sub End If Next i ActiveWorkbook.Unprotect Sheets(Master).Copy After:=Sheets(Sheets.Count) ActiveSheet.Name = s Range(A1:J58).SpecialCells(xlCellTypeConstants, 1).ClearContents Range(h13) = 12 Range(a2).Select ActiveWorkbook.Protect Structure:=True, Windows:=False End Sub Sub DeleteSheetSAS() Dim sht As String ActiveWorkbook.Unprotect On Error GoTo nosuchsheet sht = InputBox(Please Enter Sheet Name to be deleted) Application.DisplayAlerts = False Sheets(sht).Delete Application.DisplayAlerts = True ActiveWorkbook.Protect Structure:=True, Windows:=False Exit Sub nosuchsheet: MsgBox The sheet does not not exist Application.DisplayAlerts = True ActiveWorkbook.Protect Structure:=True, Windows:=False End Sub Sub NextSheetSAS() On Error Resume Next Sheets(ActiveSheet.Index + 1).Activate If Err.Number 0 Then Sheets(1).Activate End Sub Sub PreviousSheetSAS() On Error Resume Next Sheets(ActiveSheet.Index - 1).Activate If Err.Number 0 Then Sheets(1).Activate End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* ITP Abdulgani Shaikh itpabdulg...@gmail.com *Sent:* Saturday, April 14, 2012 7:14 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock Dear Freinds, I am tax practitioner and needs to make Tax working of lot of salaried employees. I have made one template for the said purpose and needs your help on some issues. My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell E13 then Cell H13 should be auto unlock for entering data. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. I want to give following option in my Tax Working Sheet 01. ADD new sheet = This option is working correctly BUT, following buttons are not 02. DELETE sheet with option to choose sheet by entering sheet name, i have tried, but its not working. Current selected sheet goes deleted. 03. PREV = Option to go to previous sheet. (Please also considering that after first sheet, it must be stopped) 04. NEXT = Option to go to next sheet. (Please also considering that after last sheet, it must be stopped) I am attaching herewith file, please guide. Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already
Re: $$Excel-Macros$$ If date in One then another cell to be unlock
Pl.reply On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, You can try this : ** ** Private Sub Worksheet_Change(ByVal Target As Range) ** ** If Target.Address = $C$3 Then Me.Unprotect If Target.Value = 0 Or Len(Target.Value) = 0 Then Range(E3).Locked = False Else Range(E3).Locked = True End If End If Me.Protect End Sub ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh *Sent:* Apr/Sat/2012 12:23 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock ** ** Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Freinds, ** ** Please help me on following issue ** ** My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. ** ** Regards ** ** -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email
Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock
Yes my file is protected and I want to keep it protected, because though file is created by me, users are different and any change in data/ formula will differ its result. Please guide. On Sun, Apr 15, 2012 at 4:24 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Is your worksheet protected? ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Abdulgani Shaikh *Sent:* Apr/Sun/2012 03:14 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock ** ** My sheet contains some tax formula and I want to keep these formula protected, if inadvertently they deleted or corrected, it will not give correct answer. ** ** If I am protecting the worksheet, it gives error at Range(A1:J58).SpecialCells(xlCellTypeConstants, 1).ClearContents ** ** Please guide ** ** Thanks a lot for everything, that's what I want really. ** ** Regards On Sat, Apr 14, 2012 at 8:34 PM, dguillett1 dguille...@gmail.com wrote:* *** On your protection, why not just leave unprotected... On your macros, see attached (Sent direct to OP) ‘--- Option Explicit Sub AddSheetSAS() ActiveWorkbook.Save Dim i As Long Dim s, k As String s = InputBox(Please Enter INITIALs of Employee as Sheet Name to be added) For i = 1 To Worksheets.Count k = Worksheets(i).Name If UCase(k) = UCase(s) Then MsgBox Sheet Already Exists Exit Sub End If Next i ActiveWorkbook.Unprotect Sheets(Master).Copy After:=Sheets(Sheets.Count) ActiveSheet.Name = s Range(A1:J58).SpecialCells(xlCellTypeConstants, 1).ClearContents Range(h13) = 12 Range(a2).Select ActiveWorkbook.Protect Structure:=True, Windows:=False End Sub Sub DeleteSheetSAS() Dim sht As String ActiveWorkbook.Unprotect On Error GoTo nosuchsheet sht = InputBox(Please Enter Sheet Name to be deleted) Application.DisplayAlerts = False Sheets(sht).Delete Application.DisplayAlerts = True ActiveWorkbook.Protect Structure:=True, Windows:=False Exit Sub nosuchsheet: MsgBox The sheet does not not exist Application.DisplayAlerts = True ActiveWorkbook.Protect Structure:=True, Windows:=False End Sub Sub NextSheetSAS() On Error Resume Next Sheets(ActiveSheet.Index + 1).Activate If Err.Number 0 Then Sheets(1).Activate End Sub Sub PreviousSheetSAS() On Error Resume Next Sheets(ActiveSheet.Index - 1).Activate If Err.Number 0 Then Sheets(1).Activate End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* ITP Abdulgani Shaikh itpabdulg...@gmail.com *Sent:* Saturday, April 14, 2012 7:14 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock Dear Freinds, I am tax practitioner and needs to make Tax working of lot of salaried employees. I have made one template for the said purpose and needs your help on some issues. My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell E13 then Cell H13 should be auto unlock for entering data. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. I want to give following option in my Tax Working Sheet 01. ADD new sheet = This option is working correctly BUT, following buttons are not 02. DELETE sheet with option to choose sheet by entering sheet name, i have tried, but its not working. Current selected sheet goes deleted. 03. PREV = Option to go to previous sheet. (Please also considering that after first sheet, it must be stopped) 04. NEXT = Option to go to next sheet. (Please also considering that after last sheet, it must be stopped) I am attaching herewith file, please guide. Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible
$$Excel-Macros$$ If date in One then another cell to be unlock
Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. Regards -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ If date in One then another cell to be unlock
Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. Regards -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
Heartiest congratulations !!! On Sat, Apr 14, 2012 at 2:13 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Congrats DON ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain *Sent:* Apr/Sat/2012 02:06 *To:* excel-macros *Subject:* $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett** ** ** ** Dear members, Don Guillett has been selected as 'Most Helpful Member' for the month of March'12 He has been helping forum members from long time consistently and we are proud to have him in the forum. He is business degree holder from University of Texas and retired Regional Manager for ING. Don, Many Many Thanks for your great contribution to forum. Keep Posting !! Best regards, Ayush Jain Group Manager, Microsoft MVP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ If date in One then another cell to be unlock
I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, You can try this : ** ** Private Sub Worksheet_Change(ByVal Target As Range) ** ** If Target.Address = $C$3 Then Me.Unprotect If Target.Value = 0 Or Len(Target.Value) = 0 Then Range(E3).Locked = False Else Range(E3).Locked = True End If End If Me.Protect End Sub ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh *Sent:* Apr/Sat/2012 12:23 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock ** ** Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Freinds, ** ** Please help me on following issue ** ** My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. ** ** Regards ** ** -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ If date in One then another cell to be unlock
Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. Also tell me what is private sub function in macro. Regards On Sat, Apr 14, 2012 at 3:48 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: Pl.reply On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, You can try this : ** ** Private Sub Worksheet_Change(ByVal Target As Range) ** ** If Target.Address = $C$3 Then Me.Unprotect If Target.Value = 0 Or Len(Target.Value) = 0 Then Range(E3).Locked = False Else Range(E3).Locked = True End If End If Me.Protect End Sub ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh *Sent:* Apr/Sat/2012 12:23 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be unlock ** ** Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh itpabdulg...@gmail.com wrote: Dear Freinds, ** ** Please help me on following issue ** ** My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. ** ** Regards ** ** -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******
Excellent, expert in Excel as well expert Poet What a combination...Great. 2012/3/23 Venkat CV venkat1@gmail.com Dear Noorain, Superb *Best Regards,* *Venkat * *Chennai* 2012/3/23 NOORAIN ANSARI noorain.ans...@gmail.com जहाँ Excel के दीवानों की, है बहूत घनी आबादी. जहाँ Question,Answer करने की,है खूब आज़ादी. जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया. चाहे सुबह हो या शाम, चाहे दिन हो या रात. हर समय होती है यहाँ पोस्टिंग की बरसात. ये उपवन सजा है दोस्तों, कई Talented फूलों से. यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से. Logic की खेती होती है यहाँ solutions के खलिहानों में. यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में.. जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया. *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है. Man of BT *Krishna* के solution को दुनिया तरसती है. *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है. *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है. और भी यहाँ बहूत सारी शख्सियत है निराली. *Ayush* बाबू करते है इस बगीया की रखवाली. ये forum अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया. दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया. -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * * * -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
Hearty Congratulation for doing such great job. I myself learn VBA through this forum only. Can you please tell me something more on Microsoft MVP Excel Regards On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members,** I am proud to announce that the forum has completed 5 years today. This is really great milestone of the forum. My sincere thanks to each one of you who keep this forum alive by asking questions and helping others by providing solutions. Over the last five years, I have seen decent growth in the number of posts and quality of solutions provided by the experts here. I have learned many things from this forum and experts. In my view, Learning never stops and the discussion forum is the best place to learn and share the skills. I hardly get time to resolve the excel queries after office hours but I try my best to moderate the forum closely. I visit the forum 2-3 times daily to approve the messages and to check everything is ok. Please let me know the improvements and changes you want to see in the forum. I would be happy to hear your feedback. Some key achievements of this forum in numbers: 1) In last 1.5 years, we have seen three people receiving the Microsoft MVP award from this forum. This is itself a big achievement for forum and I hope to see more deserving people get this award in future. 2) This is spam free forum and we hardly get spam messages. In last 5 years, 1000 members are banned for sending spam messages 3) We are 8400+ members with diversity in expertise, experience and location. 4) Over 7600+ topics discussed in five years Once again many thanks and congratulations to all of you. Keep posting and together we will achieve more milestones. Regards, Ayush Jain Microsoft MVP Forum Owner jainayus...@gmail.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....
Thanks a log Indrajit, I am searching for such kind of solution, as you are already working on log-out time tracking, please send after completion of your VB code. Regards On Thu, Mar 22, 2012 at 3:51 AM, Indrajit $nai talk2indra...@gmail.comwrote: Thanks @ Ranjan, but I don't track it in MS-Access File, can you incorporate this codes for MS-Excel? Thanks @ dguillett1, but I'm not able to use the same code for Logout time tracking in a different column, can you please help me once again? @ Abdulgani Shaikh, I have attached the same file in .xls format. On Wed, Mar 21, 2012 at 11:12 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** It’s a old post on this group ,I have created a small tool to track punch in and punch out Time , hope it can help. ** ** ‘=*** * Hi Lokesh, I am attaching Two files here.. 1). Save Access file at Shared Location. 2). In Code Module Replace *Thisworkbook.Path* with shared Path 3). Fill *AllEmpID* table in *Database* with EMPID for validation. ** ** ObjConnection.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source= *ThisWorkbook.Path* \table.accdb ; ** ** ‘=*** * ** ** ** ** Regards Rajan ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Mar/Wed/2012 03:17 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a small help, related to the Date and Time macro. ** ** Hi All, Need a small help from you all. I have attached a file with this mail. Now if you open the file you can see there is a button named Login, if you click on it, it will take the system time and date. There are two columns available, Name (Column A) and Login Time (Column B), now I want if the respective Column A is blank then it will not put the date and time in Column B, if there is a name in column A then only date and time will be captured in the column B, other wise it will give me a error message. If you have the code for the same then please provide me. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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
Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari
Really you are helpful, no prompt helpful, no full of helping nature. Hearty congratulation !!! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Jan'12 He has posted 175 posts in Jan'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru , Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com noorain.jpg
Re: $$Excel-Macros$$ Display numbers in Lakhs
This is really good, but gives answer in million format and not in Indian lakh. Regards On Sun, Jan 29, 2012 at 11:35 AM, Mohammed Muneer mmun...@ccc.com.qawrote: Mr. Prabhu go to Format cells: Go to Numbers - currency - select Indian RUPEES - Then immediately come out from currency and go to customs - do little correction like this (chk the att copy of jpg file Regards, Muneer, CC... -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Sunday, January 29, 2012 8:42 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Display numbers in Lakhs Hi, In Excel I needs to convert numbers in to indian format and the value should divided by lakhs and display in Lakhs. Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian format) Plz help. Regards, Prabhu -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to create Form for storing data
Thanks Sir, for your prompt reply. Can you please tell me how you have created the button/shape ? I will be back to you after completing whole macro. Regards On Wed, Dec 21, 2011 at 7:29 PM, dguillett1 dguille...@gmail.com wrote: 1. You would want a macro to export the master sheet data to the next available row in the db. A button/shape when filled in. 2. Another macro to import db data back to master. See attached A note to all. When attaching files please give your name and meaningful name such as attached. You may rename when final. Don Guillett SalesAid Software dguille...@gmail.com *From:* ITP Abdulgani Shaikh itpabdulg...@gmail.com *Sent:* Wednesday, December 21, 2011 2:38 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to create Form for storing data Dear Friends, I am Tax Practitioner. I have to calculate tax to be payable by each Salaried employees (say 200 in numbers), format of Computation of Tax Liability is in attached file (Sheet name Master). For calculating 200 employees tax liability I have to always create new sheet (By pressing Common Button at J1). My query is 01. When I entered data in Master Sheet, it should be stored in next Data Sheet. Field name and Data from where (Cell reference) to be captured is given in attached file. 02. Data can be retrieved by selecting EM Code given at cell A1. eg.There are 200 employees, I want to see calculation of EM 85, when I select EM85 from Master Sheet, all relevant data should re-appear in Master sheet from Data Sheet. Please guide Regards -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Want to hide entire row
Thanks Sir, Its working, but it also hide its heading, is there any solution for not to hide Column heading. (First three rows are heading) Regards On Fri, Dec 2, 2011 at 8:13 PM, dguillett1 dguille...@gmail.com wrote: Option Explicit Sub ShowNegativesInColumnsI_L_SAS() Dim i As Long Application.ScreenUpdating = False On Error Resume Next For i = Cells(Rows.Count, b).End(xlUp).Row - 1 To 1 Step -1 If Cells(i, I) = 0 Or Cells(i, L) = 0 Then _ Rows(i).Hidden = True Next Application.ScreenUpdating = True End Sub Sub UnhideRows() Rows.Hidden = False End Sub ‘ Don Guillett SalesAid Software dguille...@gmail.com *From:* AbdulGani Shaikh itpabdulg...@gmail.com *Sent:* Thursday, December 01, 2011 9:45 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Want to hide entire row Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh abdulgani.sha...@sarda.co.in wrote: I want to hide entire row if value in column *I* column *L* is greater than or equal to *0*. In other words if value in column i l is less than zero then only such row to be shown otherwise hidden. Pl help Regards -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Want to hide entire row
Thanks Sir, Its working, but it also hide its heading, is there any solution for not to hide Column heading. (First three rows are heading) This code hides all row having positive value in *both* column i.e. *I* *L*. If value in any one column may be in *I* OR *L* is positive,* *then how to show that particular row ? Regards On Sun, Dec 4, 2011 at 3:13 PM, AbdulGani Shaikh itpabdulg...@gmail.comwrote: Thanks Sir, Its working, but it also hide its heading, is there any solution for not to hide Column heading. (First three rows are heading) Regards On Fri, Dec 2, 2011 at 8:13 PM, dguillett1 dguille...@gmail.com wrote: Option Explicit Sub ShowNegativesInColumnsI_L_SAS() Dim i As Long Application.ScreenUpdating = False On Error Resume Next For i = Cells(Rows.Count, b).End(xlUp).Row - 1 To 1 Step -1 If Cells(i, I) = 0 Or Cells(i, L) = 0 Then _ Rows(i).Hidden = True Next Application.ScreenUpdating = True End Sub Sub UnhideRows() Rows.Hidden = False End Sub ‘ Don Guillett SalesAid Software dguille...@gmail.com *From:* AbdulGani Shaikh itpabdulg...@gmail.com *Sent:* Thursday, December 01, 2011 9:45 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Want to hide entire row Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh abdulgani.sha...@sarda.co.in wrote: I want to hide entire row if value in column *I* column *L* is greater than or equal to *0*. In other words if value in column i l is less than zero then only such row to be shown otherwise hidden. Pl help Regards -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Want to hide entire row
Gr8, thanks a lot, its working, this saves my lot of time to hide each row one by one. Thanks once again. Regards On Sun, Dec 4, 2011 at 5:38 PM, Sam Mathai Chacko samde...@gmail.comwrote: 1. change Cells(Rows.Count, b).End(xlUp).Row - 1 To *4* Step -1 2. Change If Cells(i, I) = 0 And Cells(i, L) = 0 Then Rows(i).Hidden = True else Rows(i).Hidden = False End if Regards, Sam Mathai Chacko On Sun, Dec 4, 2011 at 3:27 PM, AbdulGani Shaikh itpabdulg...@gmail.comwrote: Thanks Sir, Its working, but it also hide its heading, is there any solution for not to hide Column heading. (First three rows are heading) This code hides all row having positive value in *both* column i.e. *I* *L*. If value in any one column may be in *I* OR *L* is positive,* *then how to show that particular row ? Regards On Sun, Dec 4, 2011 at 3:13 PM, AbdulGani Shaikh itpabdulg...@gmail.com wrote: Thanks Sir, Its working, but it also hide its heading, is there any solution for not to hide Column heading. (First three rows are heading) Regards On Fri, Dec 2, 2011 at 8:13 PM, dguillett1 dguille...@gmail.comwrote: Option Explicit Sub ShowNegativesInColumnsI_L_SAS() Dim i As Long Application.ScreenUpdating = False On Error Resume Next For i = Cells(Rows.Count, b).End(xlUp).Row - 1 To 1 Step -1 If Cells(i, I) = 0 Or Cells(i, L) = 0 Then _ Rows(i).Hidden = True Next Application.ScreenUpdating = True End Sub Sub UnhideRows() Rows.Hidden = False End Sub ‘ Don Guillett SalesAid Software dguille...@gmail.com *From:* AbdulGani Shaikh itpabdulg...@gmail.com *Sent:* Thursday, December 01, 2011 9:45 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Want to hide entire row Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh abdulgani.sha...@sarda.co.in wrote: I want to hide entire row if value in column *I* column *L* is greater than or equal to *0*. In other words if value in column i l is less than zero then only such row to be shown otherwise hidden. Pl help Regards -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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
$$Excel-Macros$$ Excel to PDF
Dear Noorain, I have gone through your code of Excel to PDF, but it is not working. Please guide where I am wrong. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Want to hide entire row
Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh abdulgani.sha...@sarda.co.in wrote: I want to hide entire row if value in column *I* column *L* is greater than or equal to *0*. In other words if value in column i l is less than zero then only such row to be shown otherwise hidden. Pl help Regards -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com