Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect worksheet but allow users to use specific columns/cells | Excel Discussion (Misc queries) | |||
Protect cells from other users w/out me having to enter pw | Excel Discussion (Misc queries) | |||
protect cells in excel to prevent users from deleting formulae | Excel Discussion (Misc queries) | |||
How can I protect cells and allow users to insert/delete | Excel Worksheet Functions | |||
Protecting cells in Excel so that users can only paste in text | Excel Programming |