-------------------------------------------- On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Combine two macros in to one To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 8:09 PM -------------------------------------------- On Wed, 12/14/16, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Combine two macros in to one To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, December 14, 2016, 3:57 PM Your buttons call two separate macros.Print_OptionandSUPPRESS_ROWS to combine the two, simply have the Print_Option macro "call" the SUPPRESS_ROWS macro, like: Sub Print_option() SUPRESS_ROWS Application.Dialogs(xlDialogPrint).Show End Sub 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 Wednesday, December 14, 2016 2:40 AM, Vijayendra Rao <vijayendrar...@gmail.com> wrote: Dear Experts, I have created two macros, one is for suppress zero rows and another print option. Currently I need to run first suppress zero rows and later print macros. Is it possible to combine both the macros. By running print option, rows should be suppress and later need to show print dialogue option. Attached is the file which is I have created the macros. Request you to help on the same. Regards, Vijayendra 94491 67631 -- 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. ricum insa multe din masurile guvernelor liberale au prevazut protejarea economiei nationale si incurajarea sistemului bancar. in lupta pentru egalitate in cursa pentru puterea politica burghezia a luptat pentru modificarea sistemului colegiilor electorale. in 1884 Constitutia a fost modificata in sensul reducerii numarului colegiilor de la patru la trei. Prin aceasta marii proprietari industriali au gasit si ei sprijin in plan politic. Nu a fost insa vorba despre o modificare de substanta votul avand in continuare un caracter restrictiv. Fata de abordarea problemei agrare liberalii au manifestat unele rezerve propunand drept solutie constituirea Casei Rurale. Dupa 1890 partidul si-a consolidat prestigiul o data cu conturarea la conducerea sa a unei grupari de oameni politici tineri in frunte cu Ion I.C. Bratianu. Aceasta s-a sprijinit intre altii si pe Constantin Stere reprezentant al curentului poporanismului si pe asa-zisii generosi1 ce parasisera partidul socialist. in noul program adoptat in 1913 liberalii au lansat propunerea efectuarii a doua reforme fundamentale: electorala si agrara ce corespundeau stadiului si necesitatilor de dezvoltare a tarii. -- 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.ot de aici Tudor s\ Adunarea norodului constituita la Pades au intreprins demersuri diplomatice la Poarta Austria si Rusia carora le solicita sprijinul aratandu-le ca nu s-au ridicat impotriva autoritatii legitime a Portii ci impotriva stapanirii interne fanariote. Prin asigurarile date Imperiului Otoman Tudor urmarea sa impiedice o invazie armata si orice suspiciune cu privire la intentia de razvratire impotriva ordinii legale. -- 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.