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 <javascript:>>
> 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 <javascript:>, Prince Kumar - Excel <
> prince...@gmail.com <javascript:>>
>
>
> *Dear Prince*
> *
> *
> *Pl find attached file for the same.*
> *
> *
> *Regards*
> *Pravin Gunjal.*
>
> ---------- Forwarded message ----------
> From: Prince <prince...@gmail.com <javascript:>>
> 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 <javascript:>
>
>
> 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.**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.
