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
*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
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,
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
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
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
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
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
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 "
*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
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 -
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
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
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
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
15 matches
Mail list logo