| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting 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
|
|||
|
|||
|
Protecting cells in Excel so that users can only paste in text
don't think so.you could have them paste to a blank sheet
then copy it in, or use code to get th edata from the file or finally, use code to re-format the data after the import. -----Original Message----- Is there any way to protect cells in Excel so that users can only paste in text and not any formatting? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting Cells From Certain Users | Excel Discussion (Misc queries) | |||
| Can you allow users to copy & paste protects cells | Excel Worksheet Functions | |||
| protecting cells against editing by copy/paste actions | Excel Discussion (Misc queries) | |||
| protecting cells against editing by copy/paste actions | Setting up and Configuration of Excel | |||
| Protecting cells for different users | Excel Discussion (Misc queries) | |||
Hybrid Mode
