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 | |
|
|
![]() |
||||
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) |