sheet protection

[nowfal]

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

[Damon Longworth]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Kassie]

Hi nowfal

ActiveSheet.Unprotect Password:= "xyz"
do your thing
ActiveSheet.Protect Password:= "xyz"

"nowfal" wrote:

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

[nowfal]

Hi ,

I got the solution by searching an old thread in which Mr.ron and Mr.Tom oglivy had replied. The solution is as
worksheets("sheetname").portect password:="password"
add whatever the codes and all
worksheets("sheetname").unprotected Password:="password"

now my password will take care of the sheet.
anyway thanks to Mr.ron and Mr.Tom
with regards
nowfal