$$Excel-Macros$$ Protect and unprotect all sheets

2009-05-24 Thread Subu S
Thanks Andy Worked like a charm - By the way, When I saved this VBA code I gave it a name - e.g. First.xls and saved it. The macro works when I use the sheet titled first.xls. Is it possible to make this VBA work across any worksheet that I may have on my disk ? If so how ? - Is there som

$$Excel-Macros$$ Protect and unprotect all sheets

2009-05-23 Thread Subu S
Dear Members I'm new here. I'm amazed at the friendliness and Samaritan approach in this group. This place is excellent.. I'm a novice and please bear with me... Question - Let us say I wish to use the macro below. What should I do ? where should I paste it on the XL sh

$$Excel-Macros$$ Protect and unprotect all sheets

2009-05-21 Thread suresh k
Hi All, Can anyone provide the vba code to protect and unprotect all sheets in excel. Thanks & regards, Suresh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Exce