Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent pasting to more than one row
Hi folks,
I've hit a bit of a wall and can't find a solution to the following. . . I have a shared workbook, in excel 2007. The workbook contains a list of pupils' names, along with the name of the class that they are enrolled in. Users (teachers) select their own class name from a front page, a macro then autofilters the list of pupils to show only those taught by that teacher. The whole sheet is locked, then only the visible cells are unlocked. This is to prevent staff overwriting comments previously written. Teachers type reports into the cells and then save them. The problem is . . . Many teachers prefer to type their reports in word, and copy and paste them over to excel. If they include line breaks or carriage returns in their report then excel splits their comment over two cells. This isn't a problem as usually the row below the one they are pasting to is locked. Occasionally though staff will teach two students who are adjacent in the class list and can overwrite the comment in the cell below the one the are pasting to. so. . . Is there a way to prevent users pasting linebreaks or carriage returns? Many thanks Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent changes to cell references when copying and pasting | Excel Discussion (Misc queries) | |||
Prevent user from copying pasting at run time | Excel Programming | |||
Prevent Pasting | Excel Programming | |||
prevent pasting into multiple lines | Excel Programming | |||
How to prevent pasting to every sheet in workbook | Excel Programming |