A good way to begin learning VBA syntax is using the macro recorder. Record
the process of protecting and unprotecting. You can then insert this code
into your routine.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"nowfal" wrote in
message ...

hi,
I am very happy if somebody help me for writing a code to protect
the sheet
i mean first i wanted to unprotect the sheet by a password then i will
have my own line of codes and finally i wanted to protect the sheet with
the same password.
password u can use 'xyz'.

with regards
nowal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=387829