LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 14, 03:45 AM
Junior Member
First recorded activity by ExcelBanter: Aug 2013
Posts: 15
Default Protect worksheet - prevent changes to unlock cells formatting


I need to protect a worksheet with some cells still being able to input/amend data.

However, I need to control these unlocked cells to retain its formatting.
It should allows only updating of data into the cells.
Should the user copy and paste the data from other sources, these cells should still retain its formatting.

Could this be done without VB?

Many thanks in advance.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros to protect worksheet and prevent locked cell selection Excel Enthusiastic[_2_] Excel Discussion (Misc queries) 1 April 23rd 07 09:44 AM
protect cells in excel to prevent users from deleting formulae locking cells in excel Excel Discussion (Misc queries) 2 June 14th 06 05:56 PM
Prevent User to unlock Sheet Tabs Param Excel Worksheet Functions 2 March 23rd 06 02:45 AM
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. Daniel Excel Worksheet Functions 1 June 24th 05 02:59 PM
Prevent formatting Cells with Protection Rick[_25_] Excel Programming 9 April 23rd 04 02:10 AM

All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017