what will be the VB code to protect sheet. thnaks
what will be the VB code to protect sheet. thnaks
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
On Wed, 21 Dec 2005 12:42:02 -0800, "Conditional Formatting"
<[email protected]> wrote:
>what will be the VB code to protect sheet. thnaks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks