How I can protect my sheet.

[pichai]

How I can protect my sheet with password ("1234") by using the VBA CODE
(Not!! by manual).

[Kerno]

Try

Please Login or Register  to view this content.

[pichai]

Hi, thank for your code
i have some more queution, what is the vba code use for protect sheet with password" 1234" and after protect sheet .that sheet can used Use Autofilter also

[Kerno]

To filter the sheet use

Please Login or Register  to view this content.

I am not sure about the question

what is the vba code use for protect sheet with password" 1234"

If you need to protect a particular sheet use

Please Login or Register  to view this content.

[royUK]

It depends on your versin of Excel, I would first test for the version then code accordingly. Place this code in the ThisWorkBook module - see where to place your code here:http://www.excel-it.com/Forum/viewtopic.php?t=11

Please Login or Register  to view this content.