![]() |
#1
|
|||
|
|||
![]() 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! |
#2
|
|||
|
|||
![]() Quote:
|
#3
|
||||
|
||||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
fingermouse | Word | 6 | 01-14-2015 06:22 AM |
![]() |
officeboy09 | Excel | 5 | 01-16-2014 07:41 PM |
![]() |
hotmud | Word Tables | 1 | 09-29-2013 06:12 PM |
![]() |
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 |