Prevent modification of values on a protected Excel file

[DotNetUser]

I developed an Excel file that I protected by a password.

This file contains cells with input pull-down menus with the tool set/validation list.

The problem is that even when the file is protected, you can edit, copy and paste on these cells, and it overwrites the dropdown! How to prevent modification? Or only allow pasting Special Value?

[Lemog]

 Option Explicit 

  Sub DisableCopyCutAndPaste () 
  EnableControl 21, False 'cut 
  EnableControl 19, False 'copy 
  EnableControl 22, False 'paste 
  EnableControl 755, False 'pastespecial 
  Implementation. On Key "^ c", "Dummy" 
  Key Application.On "^ v", "Dummy" 
  Application.On Key "+ (DEL)", "Dummy" 
  Application.On Key "+ (INSERT)", "Dummy" 
  Application.CellDragAndDrop = False 
  Application.On DoubleClick = "Dummy" 
  CommandBars ("ToolBar List"). Enabled = False 
  End Sub 

  Sub EnableCopyCutAndPaste () 
  EnableControl 21, True 'cut 
  EnableControl 19, True 'copy 
  EnableControl 22, True 'paste 
  EnableControl 755, True 'pastespecial 
  Key Application.On "^ c" 
  Key Application.On "^ v" 
  Application.On Key "+ (DEL)" 
  Application.On Key "+ (INSERT)" 
  Application.CellDragAndDrop = True 
  Application.On DoubleClick = "" 
  CommandBars ("ToolBar List"). Enabled = True 
  End Sub 

  Sub EnableControl (Id As in protecting, Enabled As Boolean) 
  Dim CB As CommandBar 
  Dim C As CommandBarControl 

  On Error Resume Next 
  For Each CB In Application.CommandBars 
  Set C = CB.FindControl (Id: = Id, recursive: = True) 
  If Not C Is Not hing Then C. Enabled = Enabled 
  Next 

  End Sub 

  Sub Dummy () 
  '// Nogo 
  MsgBox "Sorry command not Available!" 
  End Sub

[XSI]

Clicking on a cell, then by going to Format/cell you should see a tab "Protection", to protect it.

But it would be interesting to know first that overwrites your cells and why.

If it's malicious, but unfortunately there is no simple solution.

If it is through carelessness, then you must use cells that are located in a quiet place. For example, taking cells that are not in the first columns, or not in the first few lines, or not in the first sheet.

[DotNetUser]

But in fact, it should not be protected because it is a cell attachment!

I just want the users can not change the format by pasting or otherwise.

[switchblade327]

This should help:

Private Sub Workbook_Open () 
'Ban the draw of formulas in 4 directions and the slide move 
Application.CellDragAndDrop = False 
End Sub 

Private Sub Workbook_SheetSelectionChange (ByVal Sh As Object, ByVal Target As Range) 
'Ban the collage on the same sheet as that used to copy 
Application.CutCopyMode = False 
End Sub 

Private Sub Workbook_Activate () 
'Forbidden bonding after a copy from another workbook 
Application.CutCopyMode = False 
End Sub 

Private Sub Workbook_SheetActivate () 
'Forbidden bonding after a copy from another sheet same workbook 
Application.CutCopyMode = False 
End Sub 

Private Sub Workbook_BeforeClose (Cancel As Boolean) 
'Active drawing of formulas in 4 directions and 
'the technique of drag and drop to the cells. 
Application.CellDragAndDrop = True 

'Active possible bonding 
Application.CutCopyMode = True 
End Sub

This activity has been password protected to prevent modification. In order to request an ... these values. Compare your values with your group members. .... Plot the following data using Excel and determine the highest .