Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-26-2017, 01:29 PM
KelStin KelStin is offline How can I automatically protect only certain cells in Excel 2010 Windows 10 How can I automatically protect only certain cells in Excel 2010 Office 2010 32bit
Novice
How can I automatically protect only certain cells in Excel 2010
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do You Drag & Drop Cells in Excel 2010? juliansdad Excel 4 12-05-2013 01:15 AM
Linking cells on Excel 2010 teza2k06 Excel 1 02-05-2013 01:03 AM
How can I automatically protect only certain cells in Excel 2010 Excel VBA: Worksheet_Change Cells.Protect tinfanide Excel Programming 8 04-08-2012 09:58 PM
Protect / Lock Cells / Print Set-up? meggenm Excel 3 01-26-2012 09:57 PM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft