| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
You have another reply at your other post.
my911 wrote: Sorry to hear about your trouble. However I WANT TO KILL CUT & PASTE. ..to prevent users from (unknowingly) pasting Conditional Formats and Data Validation properties into "new" cells. Have you found a way TO MAKE IT HAPPEN? Here is a segment from my Auto_Open Macro ================================================== ==== Application.DefaultSaveFormat = xlNormal Worksheets("Inputs&Actuals").Activate Sheets("Inputs&Actuals").Select Range("I6").Select CreateWorkbookMenus CreateChartMenus Application.CellDragAndDrop = False ' Added 8-28-05 Application.CutCopyMode = False Company = Range("CompanyName").Value ================================================== ===== The line that reads Application.CutCopyMode = False seems to be what I need. but it doesn't work two lines before kills Drag & Drop, but I can still Cut/Paste. Any Clues?....Help?... Debra?? -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=337783 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Special | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
| How to cut and paste with locked formulas | Excel Discussion (Misc queries) | |||
| Paste Special Question | Excel Discussion (Misc queries) | |||
Threaded Mode
