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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
ProtectWBs.xls
Description: MS-Excel spreadsheet
