Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Range
Typically, Excel users can easily click on a cell, then get the black cross
with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Range
Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop" -- Jim Cone Portland, Oregon USA (I didn't click anything) "ryguy7272" wrote in message Typically, Excel users can easily click on a cell, then get the black cross with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Rang
Thanks Jim! That will disable the drag and drop functionality totally. I
was hoping for a solution that would allow someone to drag and drop, but leave a named range in its original spot; the named range is copied and pasted from the original source to the new destination. I was hoping to find a way to just take the value, but not the named range that is attached to the cell. I guess there is not a way to do this. Is that right? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim Cone" wrote: Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop" -- Jim Cone Portland, Oregon USA (I didn't click anything) "ryguy7272" wrote in message Typically, Excel users can easily click on a cell, then get the black cross with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Rang
You could enable or disable DragAndDrop on a particular sheet
by using the Sheet_Activate/Sheet_Deactivate events. It is very difficult to prevent copying and pasting. You may need to place all of your data on a separate sheet and protect it or hide the sheet. Also, it is not clear if you are doing the copying and pasting or a user is. You can, course, just copy data from a named range and paste values. -- Jim Cone Portland, Oregon USA "ryguy7272" wrote in message Thanks Jim! That will disable the drag and drop functionality totally. I was hoping for a solution that would allow someone to drag and drop, but leave a named range in its original spot; the named range is copied and pasted from the original source to the new destination. I was hoping to find a way to just take the value, but not the named range that is attached to the cell. I guess there is not a way to do this. Is that right? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim Cone" wrote: Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop" -- Jim Cone Portland, Oregon USA (I didn't click anything) "ryguy7272" wrote in message Typically, Excel users can easily click on a cell, then get the black cross with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Rang
The user is copying/pasting. I was trying to think of a way to prevent
accidental changes of named ranges. Thats the objective. I would like to force a kind of copy-paste-special-values scenario on a particular sheet. Is there a way to ONLY prevent changes of named ranges or accidentally copying over an existing named range with new named range? Thanks, Ryan--- "Jim Cone" wrote: You could enable or disable DragAndDrop on a particular sheet by using the Sheet_Activate/Sheet_Deactivate events. It is very difficult to prevent copying and pasting. You may need to place all of your data on a separate sheet and protect it or hide the sheet. Also, it is not clear if you are doing the copying and pasting or a user is. You can, course, just copy data from a named range and paste values. -- Jim Cone Portland, Oregon USA "ryguy7272" wrote in message Thanks Jim! That will disable the drag and drop functionality totally. I was hoping for a solution that would allow someone to drag and drop, but leave a named range in its original spot; the named range is copied and pasted from the original source to the new destination. I was hoping to find a way to just take the value, but not the named range that is attached to the cell. I guess there is not a way to do this. Is that right? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim Cone" wrote: Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop" -- Jim Cone Portland, Oregon USA (I didn't click anything) "ryguy7272" wrote in message Typically, Excel users can easily click on a cell, then get the black cross with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Rang
Make a copy of the sheet. Hide it.
Use the sheet change event to compare changed cells against the hidden one. If not the same, use Application.Undo and Msgbox "Don't do that" -- Jim Cone Portland, Oregon USA "RyGuy" wrote in message The user is copying/pasting. I was trying to think of a way to prevent accidental changes of named ranges. Thats the objective. I would like to force a kind of copy-paste-special-values scenario on a particular sheet. Is there a way to ONLY prevent changes of named ranges or accidentally copying over an existing named range with new named range? Thanks, Ryan--- "Jim Cone" wrote: You could enable or disable DragAndDrop on a particular sheet by using the Sheet_Activate/Sheet_Deactivate events. It is very difficult to prevent copying and pasting. You may need to place all of your data on a separate sheet and protect it or hide the sheet. Also, it is not clear if you are doing the copying and pasting or a user is. You can, course, just copy data from a named range and paste values. -- Jim Cone Portland, Oregon USA "ryguy7272" wrote in message Thanks Jim! That will disable the drag and drop functionality totally. I was hoping for a solution that would allow someone to drag and drop, but leave a named range in its original spot; the named range is copied and pasted from the original source to the new destination. I was hoping to find a way to just take the value, but not the named range that is attached to the cell. I guess there is not a way to do this. Is that right? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim Cone" wrote: Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop" -- Jim Cone Portland, Oregon USA (I didn't click anything) "ryguy7272" wrote in message Typically, Excel users can easily click on a cell, then get the black cross with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Rang
THANKS!!
-- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim Cone" wrote: Make a copy of the sheet. Hide it. Use the sheet change event to compare changed cells against the hidden one. If not the same, use Application.Undo and Msgbox "Don't do that" -- Jim Cone Portland, Oregon USA "RyGuy" wrote in message The user is copying/pasting. I was trying to think of a way to prevent accidental changes of named ranges. Thats the objective. I would like to force a kind of copy-paste-special-values scenario on a particular sheet. Is there a way to ONLY prevent changes of named ranges or accidentally copying over an existing named range with new named range? Thanks, Ryan--- "Jim Cone" wrote: You could enable or disable DragAndDrop on a particular sheet by using the Sheet_Activate/Sheet_Deactivate events. It is very difficult to prevent copying and pasting. You may need to place all of your data on a separate sheet and protect it or hide the sheet. Also, it is not clear if you are doing the copying and pasting or a user is. You can, course, just copy data from a named range and paste values. -- Jim Cone Portland, Oregon USA "ryguy7272" wrote in message Thanks Jim! That will disable the drag and drop functionality totally. I was hoping for a solution that would allow someone to drag and drop, but leave a named range in its original spot; the named range is copied and pasted from the original source to the new destination. I was hoping to find a way to just take the value, but not the named range that is attached to the cell. I guess there is not a way to do this. Is that right? Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim Cone" wrote: Tools | Options | Edit (tab)... uncheck "Allow cell drag and drop" -- Jim Cone Portland, Oregon USA (I didn't click anything) "ryguy7272" wrote in message Typically, Excel users can easily click on a cell, then get the black cross with four arrows, and then drag and drop to another cell, to change the value of the destination cell, overwrite the contents of the cell, etc. Is there a way to disable this behavior? I dont mind users changing values of cells, but I am trying to figure out a way to prevent users from changing a named range (I have many named cells in my workbook). Id love to be able to do this for the active sheet, or for a sheet with a specific name, such as €˜Sheet1. If this is possible, obviously, it has to be done with event code. Id greatly appreciate any recommendations or suggestions. Thanks, Ryan--- |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Drag-Drop to Destination Cell; Don't Rename Named Rang
You are welcome. Glad it helped.
'-- Jim Cone "ryguy7272" wrote in message THANKS!! -- Ryan--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Drag & Drop | Excel Programming | |||
Disable drag and drop and cut and paste | Excel Programming | |||
Range ID and drag & drop to a cell | Excel Programming | |||
disable cell "drag and drop" for a cell/range meeting given condit | Excel Programming | |||
Disable drag and drop for a selected range under a certain conditi | Excel Programming |