Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2016, 03:31 AM
dlquinte dlquinte is offline format changes after locking cells Windows 10 format changes after locking cells Office 2013
Novice
format changes after locking cells
 
Join Date: Apr 2016
Posts: 3
dlquinte is on a distinguished road
Default format changes after locking cells


Hello,

I'm making an excel file that others need to fill in, therefor I locked all cells except those that need to be filled in (the only box that is checked is the one where users are authorised to select unlocked cells).
But then, after locking the worksheet and the workbook, it is still possible to change the format of a cell (like borders etc.) when they use ctrl x or ctrl c and ctrl v. Even references to those cells change, which gives me a lot of errors in other formulas I use.

How can I be sure that absolutely nothing can be changed, except for data entry in the cells, without using pop-ups etc?

Thanks!
Reply With Quote
  #2  
Old 04-21-2016, 06:07 AM
dlquinte dlquinte is offline format changes after locking cells Windows 10 format changes after locking cells Office 2013
Novice
format changes after locking cells
 
Join Date: Apr 2016
Posts: 3
dlquinte is on a distinguished road
Default

Quote:
Originally Posted by dlquinte View Post
Hello,

I'm making an excel file that others need to fill in, therefor I locked all cells except those that need to be filled in (the only box that is checked is the one where users are authorised to select unlocked cells).
But then, after locking the worksheet and the workbook, it is still possible to change the format of a cell (like borders etc.) when they use ctrl x or ctrl c and ctrl v. Even references to those cells change, which gives me a lot of errors in other formulas I use.

How can I be sure that absolutely nothing can be changed, except for data entry in the cells, without using pop-ups etc?

Thanks!
Also, is it possible to password-lock an opened file so nobody is able to close the file without the password?
Reply With Quote
  #3  
Old 04-21-2016, 08:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline format changes after locking cells Windows 7 64bit format changes after locking cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi
please don't quote whole posts unnecessarily. They are just clutter and make the thread hard to read.
Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
format changes after locking cells locking word table cells while auto-updating fields fingermouse Word 6 01-14-2015 06:22 AM
format changes after locking cells How to modify the figures and cell format in multiple cells at once? officeboy09 Excel 5 01-16-2014 07:41 PM
format changes after locking cells how to keep text format when adding new cells? hotmud Word Tables 1 09-29-2013 06:12 PM
format changes after locking cells How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Excel 2010 Format cells to use as Gantt or Plan Kizzie Excel 0 12-13-2011 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 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