|
How to Kill Copy-Paste
I have workbooks that are used by groups of 30-40 people. Although INSTRUCTION is provided warning about indiscriminate Copy-Paste (because Conditional Formatting/Data Validation/etc "travels/gets 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? -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=399902 |
requires a line in VBA as follows:
Application.CutCopyMode = False HTH "my911" wrote in message ... I have workbooks that are used by groups of 30-40 people. Although INSTRUCTION is provided warning about indiscriminate Copy-Paste (because Conditional Formatting/Data Validation/etc "travels/gets 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? -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=399902 |
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 something -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=399902 |
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 ================================================== ======== How to Kill Copy-Paste -------------------------------------------------------------------------------- requires a line in VBA as follows: Application.CutCopyMode = False HTH "my911" wrote in message ... I have workbooks that are used by groups of 30-40 people. Although INSTRUCTION is provided warning about indiscriminate Copy-Paste (because Conditional Formatting/Data Validation/etc "travels/gets 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? -- my911 -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=399902 |
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 ================================================== ======== How to Kill Copy-Paste -------------------------------------------------------------------------------- requires a line in VBA as follows: Application.CutCopyMode = False HTH "my911" wrote in message ... I have workbooks that are used by groups of 30-40 people. Although INSTRUCTION is provided warning about indiscriminate Copy-Paste (because Conditional Formatting/Data Validation/etc "travels/gets 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? -- my911 -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=399902 |
This is a line of code that has to be run after someone copies/cuts something.
It's not like .celldraganddrop (a one time thing). If you search google for "disable cut copy", you'll find 1000's of hits. Here's one: http://groups.google.co.uk/group/mic...86e9731f 7a19 or http://snipurl.com/ha1m (by Chip Pearson) my911 wrote: 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 ================================================== ======== How to Kill Copy-Paste -------------------------------------------------------------------------------- requires a line in VBA as follows: Application.CutCopyMode = False HTH "my911" wrote in message ... I have workbooks that are used by groups of 30-40 people. Although INSTRUCTION is provided warning about indiscriminate Copy-Paste (because Conditional Formatting/Data Validation/etc "travels/gets 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? -- my911 -- my911 ------------------------------------------------------------------------ my911's Profile: http://www.excelforum.com/member.php...o&userid=26733 View this thread: http://www.excelforum.com/showthread...hreadid=399902 -- Dave Peterson |
| All times are GMT +1. The time now is 06:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com