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