SOLVED

Template Creation

Occasional Visitor

So, I'm making a template for users to enter data. I find that even though I have protected the sheet if I copy a value from one cell to another, the formatting is also copied into the new cell. How do I prevent this from happening?

1 Reply
best response confirmed by patsoks (Occasional Visitor)
Solution

@patsoks 

maybe with VBA code.

 

Option Explicit
Private Sub Workbook_Activate()
    Application.CutCopyMode = False
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
End Sub

 

*The only mango...the code doesn't work if macros are disabled.

 

Additional infos:

Protection.AllowFormattingCells property (Excel)

How to protect cell formatting but only allow data entry in Excel?

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)