Hi there, do you have a list of dates for which each drop down should be locked after?
Also, and maybe this question won't help too much but I'm interested, how do you receive the selections anyway? Is it all in a sharepoint or something along those lines?
Hey Kenny, I wanted to get back to you with little more info. So each week there will usually be 5 different times where I would need cells locked. 8:00pm on Thursday, 3 different times on Sunday (1:00pm, 4:15pm, and 8:30pm), and 8:30pm on Monday. Once they lock, they stay locked. I think I finally found a solution for locking which I will paste below but I still don't know how I am going to share this workbook. I need to give 500 people access to this workbook so they can go into it and make their own selection and it save on the fly. Of course I will have restrictions on each person on what they can see and edit. Google sheets, One drive, a personal website..??? I'm really not sure which of those vehicles would accommodate me the most. Maybe you can give me some insight on that. Here is the code for scheduling a macro to run and lock cells a particular date and time. The Macro that locks the cells is called "test". I recorded it.
THIS GOES IN THE "This Workbook" OBJECT
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
Private Sub Workbook_Open()
[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Application.ontime DateValue("2/24/2019") + TimeValue("10:56:00"), "test"
[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Sheets("HUMANTEAMS").Protect Password:="123456", UserInterFaceOnly:=True
End Sub[/FONT]
THIS GOES IN THE MODULE SECTION (which is the actual Macro)
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Sub test()
'
' test Macro
'[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]'
Range("C5:E5").Select
Selection.Locked = True
Selection.FormulaHidden = False
End Sub
[/FONT]
When protecting the worksheet I have the top two selections checked
þ select locked cells
þ select unlocked cells.
This works even if the worksheet is closed or open. I'm assuming all I have to is add the other times and make it occur on a weekly basis. Thanks for your interest.