Re: $$Excel-Macros$$ VBA code to sort all worksheet tabs alphabetically, except some.

2013-01-18 Thread amar takale
Dear Yahya Muhammad, Can you post this code fully bcos I unknown vba.So pls post this code full detail then I can copy it & try Thanks in Advance Regrads Amar On Fri, Jan 18, 2013 at 4:23 PM, Yahya Muhammad wrote: > > Thanks David. Got it. > > > On Fri, Jan 18, 2013 at 1:24 PM, David Grugeon wro

Re: $$Excel-Macros$$ VBA code to sort all worksheet tabs alphabetically, except some.

2013-01-18 Thread Yahya Muhammad
Thanks David. Got it. On Fri, Jan 18, 2013 at 1:24 PM, David Grugeon wrote: > Put the four sheets at the beginning of the workbook and change the "for x > =1to worksheets.count". To "for x = 5 to worksheets.count" > > > On Friday, 18 January 2013, Yahya Muhammad wrote: > >> Dear Experts >> >> I

Re: $$Excel-Macros$$ VBA code to sort all worksheet tabs alphabetically, except some.

2013-01-18 Thread David Grugeon
Put the four sheets at the beginning of the workbook and change the "for x =1to worksheets.count". To "for x = 5 to worksheets.count" On Friday, 18 January 2013, Yahya Muhammad wrote: > Dear Experts > > I have a workbook with a no. of worksheets. New worksheets are being added > to it regularly.

$$Excel-Macros$$ VBA code to sort all worksheet tabs alphabetically, except some.

2013-01-17 Thread Yahya Muhammad
Dear Experts I have a workbook with a no. of worksheets. New worksheets are being added to it regularly. I am using below code to sort the worksheets after the addition of any new sheets. Now I need your help to modify this code so that it will keep some of the sheets (say named "Summary", "Profil