people you can,
As long as ever you can.” - John Wesley
-
From: Prabhu Pinky
To: excel-macros@googlegroups.com
Sent: Fri, May 17, 2013 7:56:56 AM
Subject: Re: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.
Hi experts,
i
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
hn Wesley
> *-
>
>
> --
> *From:* DHAMODHARAN KARTHIKEYAN
> *To:* Paul Schreiner ;
> excel-macros@googlegroups.com
> *Sent:* Thu, May 16, 2013 2:41:06 PM
> *Subject:* Re: Fwd: Fwd: $$Excel-Macros$$ PROTECT
r you can.” - John Wesley
-
From: DHAMODHARAN KARTHIKEYAN
To: Paul Schreiner ; excel-macros@googlegroups.com
Sent: Thu, May 16, 2013 2:41:06 PM
Subject: Re: Fwd: Fwd: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.
Dear Friend,
At th
> *From:* DHAMODHARAN KARTHIKEYAN
> *To:* schreiner_p...@att.net
> *Sent:* Thu, May 16, 2013 12:16:25 PM
> *Subject:* Fwd: Fwd: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.
>
>Dear Friend,
>
> Please do not mistake.
>
> I am a harmless per
response = vbYes Then
...
ElseIf response = vbNo Then
...
Else
Exit For
End If
Result included below...
Paul
From: DHAMODHARAN KARTHIKEYAN
To: excel-macros@googlegroups.com
Sent: Thu, May 16, 2013 11:39:32 AM
Subject: Fwd: $$
o all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* DHAMODHARAN KARTHIKEYAN
*To:* excel-macros@googlegroups.com
*Sent:* Thu, May 16, 2013 10:10:53 AM
*Subject:* $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.
Dear Friend(s),
*S
From: DHAMODHARAN KARTHIKEYAN
To: excel-macros@googlegroups.com
Sent: Thu, May 16, 2013 10:10:53 AM
Subject: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.
Dear Friend(s),
SUB : PROTECT EACH SHEET WITH MSG BOX.
I have a request on the following VBA Codes (this, I have collected f
