Code to protect sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Conditional Formatting - 21 Dec 2005 20:42 GMT

what will be the VB code to protect sheet. thnaks

Reply to this Message

Gord Dibben - 21 Dec 2005 23:04 GMT

With a password or not?

These apply a password.

Sub SHEETPROTECT()
ActiveSheet.Protect Password:="justme"
End Sub

Sub SHEETUNPROTECT()
ActiveSheet.Unprotect Password:="justme"
End Sub

Note: if youe users are snoopy, you should lock your VBA Project for viewing.

And be aware that worksheet and workbook protection is easily cracked so
protecting a sheet only prevents accidents.

Gord Dibben Excel MVP

>what will be the VB code to protect sheet. thnaks

Reply to this Message