98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
VBA
Resolved · Low Priority · Version 2003
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
Tue 3 Mar 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sum Up All the Values in A ColumnIf you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be: |
