Friday, August 1, 2008
Lock Cells with Button and Macro
In this post, you will see guidance how to lock cells using button control panel and macro.
Because animation picture are a little big (600kb), so you must click Readmore link below. It will directing you to full post.
The code are: (from Jim Gordon)
Sub LockemUp()
' LockemUp Macro
' Macro recorded 7/30/2008
Cells.Select
Selection.Locked = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment