Thu 19 Feb 2009, 16:34Delegate Jeffrey said...
Jeffrey has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
VBA
How do you password protect a sheet in VBA?
Wed 25 Feb 2009, 18:57Trainer Ronan said...
RE: VBA
Jeffrey
To Protect a sheet
Sub ProtectSheet()
Dim Password
Password = "test"
ActiveSheet.Protect Password, True, True, True
End Sub
and to un-protect
Sub UnProtectSheet()
Password = "test"
ActiveSheet.Unprotect Password
End Sub
Kind Regards
