Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-18-2016, 11:35 PM
ufopilot ufopilot is offline Clear data from unlocked cells Windows XP Clear data from unlocked cells Office 2007
Novice
 
Join Date: Oct 2015
Posts: 6
ufopilot is on a distinguished road
Default

Maybe the cells that were once unprotected are somehow changed to protected?
You can also place this in your code:
Code:
ActiveSheet.Unprotect

then at the end of your code:

Code:
ActiveSheet.Protect
You may want to make sure that you are indeed clearing data from unlocked or unprotected cells.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data from certain Cells in new sheet zain_shaikh Excel Programming 1 02-11-2015 07:35 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
data in some cells moving Sherriann Excel 1 08-07-2013 06:52 AM
How can I fill the below emty cells with above cell data? Learner7 Excel 8 06-28-2011 12:10 PM
Clear data from unlocked cells How to combine different cells data in one cell? Learner7 Excel 1 07-28-2010 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 AM.


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