$$Excel-Macros$$ Re: Same macro for multiple sheets

Hi Pravin, You may use this Public Sub Protect_Unprotect() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks If g_blnUpdate = True Then g_blnUpdate = False .Protect ElseIf g_blnUpdate = False Then g_blnUpdate = True

Re: $$Excel-Macros$$ Re: Same macro for multiple sheets

Thanks Prince. It's working fine. Regards Pravin. On Thu, Apr 18, 2013 at 11:55 AM, Prince prince141...@gmail.com wrote: Hi Pravin, You may use this Public Sub Protect_Unprotect() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks If g_blnUpdate =