Am absolute novice but self training.
The following code does task intended but having trouble writing macro to use msgbox reply.
Macro to ask "Is all Data ready and correct?" If Yes then ask,
" Please enter current Column Number then press OK"
"Your data will be locked and can not be changed"
A No or Cancel will end Macro and return to sheet1 (Master) as this code currently does.
Macro will be manually activated by a Button.
Then this is where I have difficulty.
OK will use entered data to modify ("E") portion of third line of code below and run.
The following code does task intended but having trouble writing macro to use msgbox reply.
Macro to ask "Is all Data ready and correct?" If Yes then ask,
" Please enter current Column Number then press OK"
"Your data will be locked and can not be changed"
A No or Cancel will end Macro and return to sheet1 (Master) as this code currently does.
Macro will be manually activated by a Button.
Then this is where I have difficulty.
OK will use entered data to modify ("E") portion of third line of code below and run.
VBA Code:
Sub Locker()
ActiveSheet.Unprotect
Columns("E").Select
Selection.Locked = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ThisWorkbook.Save
End
End Sub
Last edited by a moderator: