Hi Prince Then please let me know , how can I do the changes. Regards Pravin.
---------- Forwarded message ---------- From: Prince <prince141...@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-macros@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/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. -- 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.