View Single Post
 
Old 03-26-2017, 01:29 PM
KelStin KelStin is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Mar 2017
Posts: 4
KelStin is on a distinguished road
Default How can I automatically protect only certain cells in Excel 2010

I have a multiple user spreadsheet which is used to pass information from shift to shift. I have a drop down used to choose which person entered information and I am using a NOW function to automatically enter date and time once something is selected in the drop down. I would like to make the date and time lock in upon entry, or even the entire row would be fine. I only want only the row used to be protected while the remaining blank rows can still be used. Any help is greatly appreciated.
Reply With Quote