$$Excel-Macros$$ Re: how to make read only file in the particular folder

2009-01-04 Thread vijender kumar
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

$$Excel-Macros$$ Re: how to make read only file in the particular folder

2008-12-31 Thread Tom Jeffries
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 provide