Hi Pravin
Sry For delay reply.
Please Replace moule1 Sub from below One
Public Sub setupdate()
With ThisWorkbook.Worksheets("Field Emails")
If g_blnUpdate = True Then
g_blnUpdate = False
.Protect
ElseIf g_blnUpdate = False Then
g_blnUpdate = True
.Unprotect
End If
End With
End Sub
and Also the shape that i have added on "Field Emails" Sheet edit its
text as "Unprotect/Protect" as this will allow you to unprotect your
sheet when you want to update your sheet and click again on it to protect
your sheet once your work is over on this sheet.
Hope this time it will be fine for you. :)
Regards
Prince
On Tuesday, 18 December 2012 15:10:51 UTC+5:30, Pravin Gunjal wrote:
>
> *Dear Prince,*
>
> * *
>
> *This is not working as per my requirement. As I would like to work in
> this sheet, by un-protecting the sheet. *
>
> * *
>
> *When we click on un-protect it’s doing but only to enter a single cell,
> once the enter key is pressed, it’s automatically getting protected.*
>
> * *
>
> *Pl look in to this and do the needful.*
>
> * *
>
> *With regards,**
> **Pravin Gunjal*
>
>
> ---------- Forwarded message ----------
> From: Prince <prince...@gmail.com <javascript:>>
> Date: Mon, Dec 17, 2012 at 9:35 PM
> Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with
> manual protect / unprotect
> To: excel-...@googlegroups.com <javascript:>
>
>
> Hi Pravin,
>
> PFA
>
> Regards
> Prince
>
>
> On Monday, December 17, 2012 5:24:57 PM UTC+5:30, Pravin Gunjal wrote:
>
>> Thanks for your reply Lalit.
>>
>> My question is simple :-
>> 1. I have an excel file (which is attached)
>> 2. Which is a macro enabled.
>> 3. Most of the times I can use this file only to view it - During this
>> period I would like to make it protect.
>> 4. But when there are some updataion/changes to be done in this sheet, I
>> must unprotect the sheet to do it.
>> 5. But this macro is not allowing me to do the updations, as immediately
>> this is protecting the sheet when I move from one cell to other.
>>
>> Pl look in to this and do the needful.
>>
>> Regards
>> Pravin Gunjal.
>>
>> ---------- Forwarded message ----------
>> From: Lalit Mohan Pandey <mohan.p...@gmail.com>
>> Date: Mon, Dec 17, 2012 at 4:03 PM
>> Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with
>> manual protect / unprotect
>> To: excel-...@googlegroups.com
>>
>>
>> Dear Pravin,
>>
>> Could you please explain it more when you want to protect or unprotect
>> the sheet. so that we can provide you best solution.
>>
>> Regards,
>> Lalit Mohan
>>
>> On Monday, 17 December 2012 15:51:04 UTC+5:30, Pravin Gunjal wrote:
>>
>>> Dear Prince
>>>
>>> Request for your co-operation on this issue.
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>> ---------- Forwarded message ----------
>>> From: Pravin Gunjal <isk...@gmail.com>
>>> Date: Fri, Dec 14, 2012 at 3:55 PM
>>> Subject: Fwd: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with
>>> manual protect / unprotect
>>> To: excel-...@googlegroups.com, Prince Kumar - Excel <
>>> prince...@gmail.com>
>>>
>>>
>>> *Dear Prince*
>>> *
>>> *
>>> *Pl find attached file for the same.*
>>> *
>>> *
>>> *Regards*
>>> *Pravin Gunjal.*
>>>
>>> ---------- Forwarded message ----------
>>> From: Prince <prince...@gmail.com>
>>> Date: Thu, Dec 13, 2012 at 3:18 PM
>>> Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with
>>> manual protect / unprotect
>>> To: excel-...@googlegroups.com
>>>
>>>
>>> Hi Pravin,
>>>
>>> Share your workbook.
>>>
>>> Regards
>>> Prince
>>>
>>>
>>> On Thursday, December 13, 2012 3:13:50 PM UTC+5:30, Pravin Gunjal wrote:
>>>
>>>> Dear Prince,
>>>>
>>>> By doing the changes suggested by you, the macro is not working
>>>> properly.
>>>> Pl confirm.
>>>>
>>>> Regards
>>>> Pravin.
>>>>
>>>> ---------- Forwarded message ----------
>>>> From: Prince <prince...@gmail.com>
>>>> Date: Thu, Dec 13, 2012 at 2:44 PM
>>>> Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with
>>>> manual protect / unprotect
>>>> To: excel-...@googlegroups.com
>>>>
>>>>
>>>> Hi Pravin,
>>>>
>>>> You should palce this code on Worksheet_Activate() event and befor
>>>> udating the sheet protact it.For updating the sheet unprotact it from menu
>>>> bar.
>>>>
>>>> regards
>>>> Prince
>>>>
>>>>
>>>> On Thursday, December 13, 2012 2:29:57 PM UTC+5:30, Pravin Gunjal wrote:
>>>>
>>>>> Hi Prince
>>>>> Then please let me know , how can I do the changes.
>>>>>
>>>>> Regards
>>>>> Pravin.
>>>>>
>>>>> ---------- Forwarded message ----------
>>>>> From: Prince <prince...@gmail.com>
>>>>> Date: Thu, Dec 13, 2012 at 2:09 PM
>>>>> Subject: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with
>>>>> manual protect / unprotect
>>>>> To: excel-...@googlegroups.com
>>>>>
>>>>>
>>>>> Hi Pravin,
>>>>>
>>>>> Whenever you move from one cell to other Worksheet_SelectionChange event
>>>>> is called thats why it is not allowing you to update the sheet.
>>>>>
>>>>> Regards
>>>>> Prince
>>>>>
>>>>>
>>>>> On Thursday, December 13, 2012 1:24:00 PM UTC+5:30, Pravin Gunjal
>>>>> wrote:
>>>>>>
>>>>>> *Dear Friends,*
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> *I am using the following macro in one of my excel files. *
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)*
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> * With ThisWorkbook.Worksheets("Field Emails")*
>>>>>>
>>>>>> * .Unprotect*
>>>>>>
>>>>>> * [selRow] = Target.Row*
>>>>>>
>>>>>> * [selCol] = Target.Column*
>>>>>>
>>>>>> * .Protect*
>>>>>>
>>>>>> * End With*
>>>>>>
>>>>>> *End Sub*
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> *I used to work in this file with protect sheet and sometimes I
>>>>>> would like to work with unprotect sheet to update the data. *
>>>>>>
>>>>>> *But the below code is not allowing me to keep file unprotect as
>>>>>> it’s automatically protecting the sheet once I move to the another cell.
>>>>>> *
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> *Therefore, I request you to please inform me some
>>>>>> corrections/addition in to this code to enable me to work with or
>>>>>> without
>>>>>> protection. Protect / unprotect should be happened manually and not
>>>>>> automatically.*
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> *Thank you,*
>>>>>>
>>>>>> * *
>>>>>>
>>>>>> *With regards,**
>>>>>> **Pravin Gunjal*
>>>>>>
>>>>> --
>>>>> Join official Facebook page of this forum @ https://www.facebook.com/*
>>>>> *discu******ssexcel <https://www.facebook.com/discussexcel>
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>> To unsubscribe from this group, send email to excel-macros...@**
>>>>> googlegroups.**c****om.
>>>>>
>>>>> Visit this group at http://groups.google.com/**group******
>>>>> /excel-macros?hl=en<http://groups.google.com/group/excel-macros?hl=en>
>>>>> .
>>>>>
>>>>>
>>>>>
>>>>> --
>>>> Join official Facebook page of this forum @ https://www.facebook.com/**
>>>> discu****ssexcel <https://www.facebook.com/discussexcel>
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>> To unsubscribe from this group, send email to excel-macros...@**
>>>> googlegroups.**c**om.
>>>> Visit this group at http://groups.google.com/**group****
>>>> /excel-macros?hl=en <http://groups.google.com/group/excel-macros?hl=en>
>>>> .
>>>>
>>>>
>>>>
>>>> --
>>> Join official Facebook page of this forum @ https://www.facebook.com/**
>>> discu**ssexcel <https://www.facebook.com/discussexcel>
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.**com.
>>> Visit this group at http://groups.google.com/**group**
>>> /excel-macros?hl=en <http://groups.google.com/group/excel-macros?hl=en>.
>>>
>>>
>>>
>>>
>>> --
>> Join official Facebook page of this forum @ https://www.facebook.com/**
>> discussexcel <https://www.facebook.com/discussexcel>
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com.
>> To unsubscribe from this group, send email to excel-macros...@**
>> googlegroups.com.
>> Visit this group at
>> http://groups.google.com/**group/excel-macros?hl=en<http://groups.google.com/group/excel-macros?hl=en>
>> .
>>
>>
>>
>> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com<javascript:>
> .
> To unsubscribe from this group, send email to
> excel-macros...@googlegroups.com <javascript:>.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
