Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Ifcontains "yes" make A1, B1 , C1 record read only Ifcontains "yes" make A1, B1 , C1 record read only
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2016, 05:35 AM
macropod's Avatar
macropod macropod is offline Ifcontains "yes" make A1, B1 , C1 record read only Windows 7 64bit Ifcontains "yes" make A1, B1 , C1 record read only Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
What happens if someone subsequently changes B1 to something other than 'yes'? Should the other cells remain protected; or should they be unprotected?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 11-08-2016, 03:26 AM
alpha2nl alpha2nl is offline Ifcontains "yes" make A1, B1 , C1 record read only Windows 8 Ifcontains "yes" make A1, B1 , C1 record read only Office 2013
Novice
Ifcontains "yes" make A1, B1 , C1 record read only 		 
Join Date: Oct 2016
Posts: 3
alpha2nl is on a distinguished road
Default
The other cells should be unprotected. Only by "yes" protected.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Message "Unable to read file" when clicking on the Excel icon roundman Excel 3 12-03-2014 04:28 PM
Is it possible to make Word link to the last record in Excel stephen_pen Word 0 09-22-2011 11:00 PM
Ifcontains "yes" make A1, B1 , C1 record read only Mailing: how to make the "page number" in Word is the same as "row number" in excel w Jamal NUMAN Word 1 09-03-2011 11:37 AM
Monitoring "Record Narration"? knewman PowerPoint 1 04-23-2011 04:59 PM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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