Hi Tom, Thanks for helping me but I have a question when I ran this macro the file get protect and open as read only. but read only should not get change unless I unprotect it with password. I tried macro you sent to me. The file I have protect through this macro I can easily unprotect with giving the password which I used to protect the file.I just to Tool and call the unprotect sheet then file is allowing to make any changes which I dont want.
Thanks for your help. On 12/31/08, Tom Jeffries <tjeff...@gmail.com> wrote: > > The attached Workbook contains a macro (ProtectWBs) which I believe does > what you want. Enter the complete path name for the starting point eg. > C:\FilestToProtect and the password when prompted. Each Workbook (and its > Sheets) along the specified path will be protected using the password > provided. If you have any questions let me know. > > Regards, > Tom > > On Tue, Dec 30, 2008 at 2:05 AM, vijender kumar <simplevi...@gmail.com>wrote: > >> Hi to All, >> >> I have problem if you guys have solution then please provide me. >> >> My probelm is I have 20 or 30 folders and each folder containing 30 to 40 >> excel file which I have to sent to the market. and I have to protect ( read >> Only) each excel file one by one manually so that no one can make the >> change.I have do this exercise on monthly basis. Is there any option to make >> it automate through the macros. so that I can protect all of the file read >> only which is available in particular folder. >> >> or can I make all folder read only . >> >> >> > > > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---