Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELLS TO BE AUTOMATICALLY LOCKED
Dear friends your expertise is required for a piece of code that would be
attached with a button which upon being clicked shall ask in a msgbox: "You sure the information is complete and correct?" and upon clicking the "YES" all the entries would be frozen / cells locked, except for a column A:A. Thanx Guys!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELLS TO BE AUTOMATICALLY LOCKED
Maybe...
Option Explicit Sub testme() Dim resp As Long With ActiveSheet If .ProtectContents = True Then 'already protected Exit Sub End If resp = MsgBox(Prompt:="Are you sure?", Buttons:=vbYesNo) If resp = vbNo Then Exit Sub .Cells.Locked = True .Range("A1").EntireColumn.Locked = False .Protect Password:="hi" End With End Sub FARAZ QURESHI wrote: Dear friends your expertise is required for a piece of code that would be attached with a button which upon being clicked shall ask in a msgbox: "You sure the information is complete and correct?" and upon clicking the "YES" all the entries would be frozen / cells locked, except for a column A:A. Thanx Guys!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
locked cells | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Locked cells | Excel Worksheet Functions | |||
Locked cells | Excel Worksheet Functions |