$$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-17 Thread Avinash
Dear Experts, I have 1 workbook and there are 10 subsheets in that workbook. i have created 1 macro to format those 10 subsheets. every sheet does have different formatting e.g. sheet 1 bold text for row 1 and and sheet 2 bold italic text for row 2. so now i want macro to show the progress bar (

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-17 Thread Manoj Kumar
Dear Avinash. Sub gg() For a = 1 To Sheets.Count Sheets(a).Activate Range("a1:dd5").Select Selection.Font.Bold = True Next End Sub Regard Manoj On Sun, Jun 17, 2012 at 11:39 PM, Avinash wrote: > Dear Experts, > > I have 1 workbook and there are 10 subsheets in that workbook. > i hav

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Avinash
Thanks Manoj for you help. But i want progress bar macro formatting macro i already have i have mentioned sample macro code not my actual code. Regards, Avinash On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote: > > Dear Avinash. > > > Sub gg() > > For a = 1 To Sheets.Count > S

RE: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Rajan_Verma
See the attached file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Avinash Sent: 18 June 2012 2:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Progress Bas for macro status

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Avinash
verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Avinash > *Sent:* 18 June 2012 2:35 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Progress Bas for mac

RE: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Rajan_Verma
: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required Hi Rajan, Thanks for your help but can u please tell me how can i use this progress bar in to my existing code i mean it is loading directly towards the end but i want it should run like

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread dguillett1
http://oreilly.com/pub/h/2607 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Avinash Sent: Monday, June 18, 2012 10:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required Hi Rajan, Thanks for your

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Avinash
Software > dguille...@gmail.com > > *From:* Avinash > *Sent:* Monday, June 18, 2012 10:20 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help > Required > > Hi Rajan, > > Thanks for your help but can u p

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Avinash
Software > dguille...@gmail.com > > *From:* Avinash > *Sent:* Monday, June 18, 2012 10:20 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Progress Bas for macro status - Help > Required > > Hi Rajan, > > Thanks for your help but can u p

RE: $$Excel-Macros$$ Progress Bas for macro status - Help Required

2012-06-18 Thread Rajan_Verma
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Avinash Sent: 18 June 2012 10:42 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required Thanks Rajan, It works perfect. but can you do 1 thing for me i have