Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Protect cells in Excel so that users can only paste in text

Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 473
Default Protect cells in Excel so that users can only paste in text

Mike Mayer wrote:
Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?


Not directly
The best you can do is disable or remove the ability to paste other
than Paste / Values.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

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
protect worksheet but allow users to use specific columns/cells mexpedip Excel Discussion (Misc queries) 1 June 3rd 09 02:40 PM
Protect cells from other users w/out me having to enter pw Tara at Walsh Excel Discussion (Misc queries) 4 May 14th 07 10:40 PM
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
How can I protect cells and allow users to insert/delete Jammy Dodger Excel Worksheet Functions 1 January 12th 06 10:20 AM
Protecting cells in Excel so that users can only paste in text [email protected] Excel Programming 1 December 3rd 03 05:37 PM


All times are GMT +1. The time now is 10:44 AM.

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

About Us

"It's about Microsoft Excel"