Re: $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS

2013-05-17 Thread Amit Gandhi
How it is to be used? On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma wrote: > *Use it * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR > *Sent:* 17 May 2013 10:19 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Ma

$$Excel-Macros$$ Free on-line courses in computational music and functional programming are offered

2013-05-17 Thread Ambuja Salgaonkar
*Hello* *Have you ever thought of you as a Computer Scientist contributing to flourish music and get benefited? And how if my second conjecture is that a person who knows dance can know programming better? Or to make the two together, “Computing could be taught and learned by using Music and

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Eugene Bernard
Very UsefulThanks to both of you. Regards Eugene On Fri, May 17, 2013 at 8:36 PM, Abhishek Jain wrote: > The link was shared with me by Priti. She is an active learner and finds > such stuff. > > Priti - please share more links like this, if you have. > > Regards, > > Abhishek > > > On Fri,

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Abhishek Jain
The link was shared with me by Priti. She is an active learner and finds such stuff. Priti - please share more links like this, if you have. Regards, Abhishek On Fri, May 17, 2013 at 7:26 PM, Prabhu Pinky wrote: > Hi Abhishek, > > the link "http://www.excel-pratique.com/en/index.php"; you give

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Prabhu Pinky
Hi Abhishek, the link "http://www.excel-pratique.com/en/index.php"; you given is really useful. Please suggest more link like this... Regards, Prabhu R On 17 May 2013 17:43, Chaya wrote: > Dear Abhishek, > > Your tips are brilliant, thanks for sharing those clues. it will be a > great

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

2013-05-17 Thread Prabhu Pinky
Dear Vijaykumar, which file u refer to..? i dont find any attachment. On 17 May 2013 10:02, P.VIJAYKUMAR wrote: > Respected Prabhu, > > Hope this file will be of little help to u. > > > Regards, > VIJAYKUMAR > > > On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky wrote: > >> Hi all, >> >> I am ver

Re: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.

2013-05-17 Thread Paul Schreiner
What error are you getting? (I think I know the answer, but you should really have provided that with your question) Ask yourself: What is "Contents"? What is "Scenarios"? I THINK, you'll find that "Contents = True" and "Scenarios = True" are intended to be part of the ActiveSheet.Protect statem

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Chaya
Dear Abhishek, Your tips are brilliant, thanks for sharing those clues. it will be a great inspiring, rhythm of elevation towards preparing self thorough in aspect of macros. The cited *link* above is a great aspiration for a macros beginners. thanks for sharing and bringing back the life

Re: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.

2013-05-17 Thread Abhishek Jain
Try replacing it with: ActiveSheet.Protect , DrawingObjects:=True, _ Contents:=True, Scenarios:=True OR ActiveSheet.Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True Whenever part of a syntax is appended in a second line, it is mandatory to end the first line with an underscore "

Re: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.

2013-05-17 Thread Prabhu Pinky
*Hi experts, in the below code, am getting error on highlighted lines.. pls help* Sub PROTECT_EACH_SHEET() ' Loop through all sheets in the workbook For i = 1 To Sheets.Count ' Activate each sheet in turn. Sheets(i).Activate response = MsgBox("Do you want

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Abhishek Jain
Firstly, take a breath. Keep calm. Just because you're reading e-books, googling for 2 months and you don't know how to use 'Dim'...doesn't mean you should be ashamed. Humans are strange. They went to moon before figuring out that it would be handy to install little wheels in luggage. My point is -

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Chaya
Thanks David sir, yes you are right. self practice is the best platform for learning initial steps. thanks for the advice. and henceforth i will keep learning with the culture. but of all this, i think there should be a guidance which helps in learning by understanding the concepts.i mean there

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread David Grugeon
Two major things will help you. One is the help files which are invoked whenever you click on a word in a macro and then press F1. I am sure you have found that, but do you use it whenever you do not understand all about a keyword such as Dim? The other thing is intellisense. When you are typin

$$Excel-Macros$$ Macros Tips

2013-05-17 Thread Chaya
Dear experts and all, I am trying to learn excel macros from initial steps. please provide some advance tips to learn the source from initial. Actually, i am learning by recording the macros and trying to get the logic, but it does not make me fullfil to learn. even i reading ebooks and tryi

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

2013-05-17 Thread David Grugeon
Did you mean to attach the file? Regards David Grugeon On 17 May 2013 14:32, P.VIJAYKUMAR wrote: > Respected Prabhu, > > Hope this file will be of little help to u. > > > Regards, > VIJAYKUMAR > > > On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky wrote: > >> Hi all, >> >> I am very new to VBA w