How to Kill Copy-Paste

M

my911

I have workbooks that are used by groups of 30-40 people.

Although INSTRUCTION is provided warning about indiscriminat
Copy-Paste
(because Conditional Formatting/Data Validation/etc "travels/get
pasted"), I continue to get calls...."The Spreadsheet is broke".

I have found how to turn off Drag & Drop.

Is there any way to turn off Cut & Paste
 
M

my911

Jim,

Thanx for the reply.

I've tried that in my startup macro.

It seems that command is not very global or durable.

Should it work :
1. In all worksheets?
2. For all the while that the Workbook is open?

...It seems so simple/obvious, but I've not experienced that.

Am I missing somethin
 
M

my911

Jim,

I went back and tried again.
Here is a segment of my Auto_Open macro
=====================================

Application.ScreenUpdating = True
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

Drag and drop IS turned off, but I can still open the 1st (main
worksheet and COPY - PASTE.

Any more hints?

Thanx
==========================================================

Re: How to Kill Copy-Paste
 
M

my911

Jim,

I went back and tried again.
Here is a segment of my Auto_Open macro
=====================================

Application.ScreenUpdating = True
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
======================================================

Drag and drop IS turned off, but I can still open the 1st (main
worksheet and COPY - PASTE.

Any more hints?

Thanx
==========================================================

Re: How to Kill Copy-Paste
 
Top