| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
While doing multiple cell copy paste the Selection.PasteSpecial overrides the protected formula cells
I am using custom copy paste function in my Excel VBA. I trap the key
strokes for paste key and use Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlPasteSpecialOperationNone, SkipBlanks:=False, Transpose:=False function for copy paste. I have some formula cells on my excel which are protected. If I try to paste on these formula cells individually (single cell) it does not paste anything since they are protected.But when I try to paste onto multiple cells it over writes the values on to my formula cells there by losing the formulas. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .PasteSpecial Paste:=xlPasteFormulas / protected cells | Excel Programming | |||
| Exporting Logo from Access 97 to Excel 2000 by copy and pastespecial is stopping Cell A1 selection | Excel Programming | |||
| Copy paste a formula in multiple cells | Excel Programming | |||
| How to copy and paste same formula in multiple cells? | Excel Worksheet Functions | |||
Threaded Mode
