Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allows users to only paste in cell A1
I need someway of allowing users to only paste in cell A1. Now I can't
just create a user editable range and then protect the other cells as the user will be pasting a table of data exported from an external programming. I just need the data to only be allowed to be pasted in cell A1 so I can have a worksheet that links to the data, correctly use vlookup on it. How would I make it so that all the data is pasted only starting at cell A1. Also I would like to prevent the users from being able to drag a range of data as well on the worksheet. So when they paste it there should be no way of moving it around otherwise this may also mess up my vlookup formulas I have linked to the sheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allows users to only paste in cell A1
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DragAndDrop = False If Intersect(target,Columns(1)) is nothing then Application.CutcopyMode = False End if End Sub Put this in the Sheet module of the sheet You would need to enable DragAndDrop in other sheets, perhaps using the Activate events. Chip Pearson's page on events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy wrote in message oups.com... I need someway of allowing users to only paste in cell A1. Now I can't just create a user editable range and then protect the other cells as the user will be pasting a table of data exported from an external programming. I just need the data to only be allowed to be pasted in cell A1 so I can have a worksheet that links to the data, correctly use vlookup on it. How would I make it so that all the data is pasted only starting at cell A1. Also I would like to prevent the users from being able to drag a range of data as well on the worksheet. So when they paste it there should be no way of moving it around otherwise this may also mess up my vlookup formulas I have linked to the sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you allow users to copy & paste protects cells | Excel Worksheet Functions | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions | |||
Protect cells in Excel so that users can only paste in text | Excel Programming | |||
Protecting cells in Excel so that users can only paste in text | Excel Programming |