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 -~----------~----~----~----~------~----~------~--~---