Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 22nd 05, 12:39 AM
Bill Schnur
 
Posts: n/a
Default Protect Cell Formatting

I have problems with users wanting to cut and paste data in the cells. How do
I protect a worksheet to keep someone from "cutting" an unlocked cell and
pasting it in another "unlocked" region. They destroy the formatting such as
borders, backcolors, etc. and make quite a mess. I would like to retain the
ability to copy the contents of the cell but not the formatting.

  #2   Report Post  
Old March 23rd 05, 03:53 AM
Cesar Zapata
 
Posts: n/a
Default

Show them about "Paste special". when you right click you'll find that
option righ below Paste. So select paste special then select Values.
Another way to do is it trough VBA by recreating the right click menu.



Reply
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
In excel how do I protect the format of a cell but let the user c. John Louis Excel Discussion (Misc queries) 11 October 1st 07 12:03 AM
Conditional Formatting if any value in the cell Metallo Excel Worksheet Functions 5 March 4th 05 12:34 PM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 11:39 PM
How to do a conditional formatting based on an adjacent cell Confused Excel Discussion (Misc queries) 2 January 10th 05 10:55 PM
Protect Cell if value <> 0 OR blank? newbie Excel Worksheet Functions 8 December 13th 04 10:23 AM


All times are GMT +1. The time now is 04:55 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017