Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2013, 07:42 AM
gbaker gbaker is offline Protection in Excel Windows 7 32bit Protection in Excel Office 2010 32bit
Competent Performer
Protection in Excel
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Protection in Excel

I have a workbook that is being used by other employee's. Because the input screen has links to other information, we can't cut and paste information. How do I set up the sheet so that no one can cut (by mistake) and cause reference errors. Is there somewhere under protect worksheet that would keep anyone from using the cut function.
Reply With Quote
  #2  
Old 02-28-2013, 06:35 AM
OTPM OTPM is offline Protection in Excel Windows 7 32bit Protection in Excel Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Have you tried protecting the cells you dont want changed?
To do this:
1. Select the whole worksheet and untick the protect cells tick box.
2. Select those cells that you want to protect.
3. Re-tick the protect cells tick box.
4. Protect the worksheet and add a pasword if you wish.
This should provide you with what you want.
Good luck.
Tony
Reply With Quote
  #3  
Old 02-28-2013, 06:56 AM
gbaker gbaker is offline Protection in Excel Windows 7 32bit Protection in Excel Office 2010 32bit
Competent Performer
Protection in Excel
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Protection in Excel

Hi Tony,
I did protect cells that I didn't want anyone to be able to edit. These are cells that need to be edited but I don't want anyone to be able to cut & paste, Just copy and paste so I won't have reference issues on other sheets that are in the background. I found code that seems to work well for what I am trying to do.

Code:
Option Explicit
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
Select Case Application.CutCopyMode
Case Is = False
'do nothing
Case Is = xlCopy
'do nothing
Case Is = xlCut
MsgBox "Please DO NOT Cut and Paste. Use Copy and Paste; then delete the source."
Application.CutCopyMode = False 'clear clipboard and cancel cut
End Select
End Sub
Thanks for your help!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protection in Excel Password Protection JimP Visio 2 03-24-2011 04:23 AM
Document protection Daved2424 Word 0 11-17-2010 01:22 AM
Help reg Protection of cell. aligahk06 Excel 1 09-02-2009 05:45 PM
Protection in Excel need help with document protection jknyc Word 1 06-22-2009 11:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft