Re: $$Excel-Macros$$ What is the code to lock & unlock a file have protect password

2010-11-12 Thread Ajay Varshney
Sub Protect_the_workbook() ActiveWorkbook.Password = "password" ActiveWorkbook.WritePassword = "password" End Sub Sub Unprotect_the_workbook() ActiveWorkbook.Password = "" ActiveWorkbook.WritePassword = "" End Sub On Fri, Nov 12, 2010 at 8:00 PM, Rajesh K R wrote: > Hi Experts

$$Excel-Macros$$ What is the code to lock & unlock a file have protect password

2010-11-12 Thread Rajesh K R
Hi Experts i have a doubt about using macro code for locking and unlocking a file with a password pls help me Regards Rajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l