• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Column Paste Disable

A

Abhijeet

Active Member
Hi

I want If more than 2 columns paste the data not allow how to do this only single column need to allow paste please tell me
 
@Abhijeet
Make 'extra' column between columns that You want to prevent two column paste and set it's (extra column's) protection to locked (other columns have to be unlocked) and protect sheet.
Before A B C D
After A B C D E F G
(Red columns are 'new locked columns' and those will prevent two or more column paste after sheet protection. Green columns are 'old unlocked columns.)
Maybe need to make some modifications with formulas and marcos.
Same kind of method can use to prevent multirow paste.
'Users love this!', except copy-paste-users.
 
Hi Vletm

This u told me before so i am aware of this but i can not change Format
so i can not add any column so please tell me different way for this
 
You must log in or register to reply here.
Back
Top