| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent pasting into multiple lines
Hi
I have a sheet with a macro on it, which dynamically hides and shows specific rows. However, when, say, for example, all lines except 173 and 285 ar hidden, and the user wishes to copy a row to those rows, and thus selects them both, and presses ctrl-v, all the lines in between will be pasted to as well... Is there any way to prevent this with an onCopy event or something like that? Thx Bart |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prevent pasting into multiple lines
Look in HELP for SPECIALCELLS
-- Don Guillett SalesAid Software "Bart van den Burg" wrote in message ... Hi I have a sheet with a macro on it, which dynamically hides and shows specific rows. However, when, say, for example, all lines except 173 and 285 ar hidden, and the user wishes to copy a row to those rows, and thus selects them both, and presses ctrl-v, all the lines in between will be pasted to as well... Is there any way to prevent this with an onCopy event or something like that? Thx Bart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent changes to cell references when copying and pasting | Excel Discussion (Misc queries) | |||
| Is there a way to prevent pasting data into an Excel worksheet? | Excel Worksheet Functions | |||
| prevent Excel from pasting icon when it starts | Excel Discussion (Misc queries) | |||
| How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
| How to prevent pasting to every sheet in workbook | Excel Programming | |||
Linear Mode
